adding Time / time Formats

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that currently calculates time in the 00:15:36 format. Is
there a way that can change that format to read 15min 36Sec instead of
00:15:36?

Please assist
 
Ramon said:
I have a query that currently calculates time in the 00:15:36 format.
Is there a way that can change that format to read 15min 36Sec
instead of 00:15:36?

Please assist
Click to expand...

Use a format property of...

"nn\M\i\n ss\S\e\c"

or the Format() function...

=Format(FieldName, "nn\M\i\n ss\S\e\c")

BUT... note that in an Access database 00:15:36 does NOT mean 15 minutes and 36
seconds. It means 15 Minutes and 36 seconds past midnight on December 30, 1899.

Database DateTimes store "points in time" not "amounts of time". Because they
are stored under the covers as numbers you can treat them as durations (to a
point), but once you accumulate more than 24 hours they roll over to December
31, 1899 and the time portion goes back to zero.

If you need to store durations you are better off using a long integer field to
store the total number off seconds and then convert to hours and minutes for
display. All computations would be done on the number of seconds.
 
Back
Top