Time maths beyond 24:00

[Alp]

Hi Experts,

Most porbably this had been asked before and my unfortunate luck continues
iwth groups.Yahoo. search engine. Thus I'm again here...

I'm trying to add time beyaond the 24:00 hour format. i.e. past 24, it
should return 26, 35 etc...

Must be possible but the aged brain has ceased responding.

Any pointers would highly be appreciated. Thanks in advance.

Alp

 

[Douglas J. Steele]

The Date/Time field in Access is intended to store a point in time (a date
and time), not for time durations. This is because internally it's an 8 byte
floating point number, where the integer part represents the date as the
number of days relative to 30 Dec, 1899, and the decimal part represents the
time as a fraction of a day.

The usual advice is to store the time duration in a Long Integer as a number
of seconds (or number of minutes if you don't need that resolution), and to
write your own functions for translate between total seconds to hh:mm:ss.

If you're really adverse to that, though, I show a technique for getting
around the 24:00 limit in my October, 2003 Access Answers column for
Pinnacle Publication's Smart Access. You can download the column (and its
accompanying database) free from
http://members.rogers.com/douglas.j.steele/SmartAccess.html

 

[Alp]

Thanks Doug for your advice. I'll also look at your article.

Alp