Formats

[R Tanner]

Hi,

I have a spreadsheet that is linked to an access database. I have a
sum of the duration event in my spreadsheet equal to the following:
37:29:14. This is in the following Special Format: [h]:mm;ss.

After it is imported into Access, my format is changed to the
following: h:nn:ss. This same number equals: 13:29:14'

Any idea how to fix this? I am trying to run a query that sums the
duration by event and it is not working properly because this format
is not correct (I'm assuming).

Thanks

 

[Kevin B]

Try using the DateDiff function in your Access query to calculate durations.

 

[tedmi]

DateDiff works only if start and end times are available. But what if only
durations are available? E.g. a table of marathon running times?

 

[Kevin B]

If you're going to be entering durations you would have to input the hours &
minutes into 2 fields. Time values only cycle on a 24 hour clock and there
would be no way of displaying 24 hours and 2 minute duration as it doesn't
exist as a time value.