Computed Time fields from Access to Excel

L

lindacooke2000

I am creating a floating bar chart in Excel for people's
work schedules. The data comes from Access 2000. The
length of the bar is in an Access Query Duration: (Format
([EndTime]-[StartTime],"ShortTime")) computed as Time to
match the x-axis "time-of-day". The values come out as
8:30 for 8.5 hours, etc, which is perfect. Actually
comes out "08:30" - the zero in front seems to be keeping
Excel from handling the values correctly - If I
type "8:30" into the cell by hand, everything works
perfectly. I can't find a formatting function that can
fix this - any suggestions?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

30/12/1899 Error when importing Time from Excel to Access 3
Time and billing help 3
Time Format in Excel 7
Calculating Meal Period Violations in Access 2
Problem inserting time values from Access into SQL Server 5
Adding Time in Excel - Frustating experience!! 5
Excel as a sign in sheet 0
Calculate Time in A Report 5

Top