News:

BB code in posts seems to be working again!
I haven't turned on every single tag, so please let me know if there are any that are used/needed but not activated.

Main Menu

Odd issue when importing times from excel to Visio 2007

Started by jimdangereux, June 17, 2010, 02:35:36 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

jimdangereux

Hi all,

I'm rather new to visio, and come across something which is causing me great consternation. I'm thinking this isn't me, and may be an actual bug with visio, but I haven't found any evidence of anyone else having come across it. Basically, I've imported a big load of times from a spreadsheet so that I can use these to populate a rudimentary self created timeline for a workflow. The issue I'm having is that any time I import that is 12:00:00 (or 12:00:01, etc), visio displays it as 00:05:00. I am absolutely stumped by this. The time is formatted in the spreadsheet as {{hh:mm:ss}} and seems to be 24 hour. Does anyone have any idea what's going here? If you require any other information that I've missed out, please ask! This is driving me insane!

Yacine

Hi dangerous Jim,
QuoteThis is driving me insane!
We don't want you to run amok. Best send both excel and vsd and let us run amok ;).

Cheers - or shall I say salut?
Yacine

Browser ID: smf (possibly_robot)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 161 (show)
Files included: 34 - 1306KB. (show)
Memory used: 1055KB.
Tokens: post-login.
Cache hits: 13: 0.00168s for 26,733 bytes (show)
Cache misses: 2: (show)
Queries used: 16.

[Show Queries]