Author Topic: Odd issue when importing times from excel to Visio 2007  (Read 4024 times)

0 Members and 1 Guest are viewing this topic.

jimdangereux

  • Newbie
  • *
  • Posts: 1
Odd issue when importing times from excel to Visio 2007
« on: June 17, 2010, 09:35:36 AM »
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

  • Hero Member
  • *****
  • Posts: 2991
Re: Odd issue when importing times from excel to Visio 2007
« Reply #1 on: June 17, 2010, 12:22:26 PM »
Hi dangerous Jim,
Quote
This 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?
« Last Edit: June 17, 2010, 12:24:04 PM by Yacine »
Yacine