Calculating times

[Guest]

I am keeping a database for waiting times between various levels in the
hospital. All times are calculated back to an admission time. Also, the
date and time fields are two seperate fields to make data entry easier. I
have got it working and calculating as long as the total is less than 24
hours. When the total elapsed is >24 hours, my formula breaks. Any ideas????

example: admit date 2/2/05
admit time 6:00
EKG date 2/2/05
EKG Time 6:30
Discharge date 2/4/05
Disrcharge time 10:00

The EKG elapsed is calculating right at 2:00. However, the discharge will
show 4:00 instead of 52:00.

help???

 

[Allen Browne]

See:
Calculating elapsed time
at:
http://allenbrowne.com/casu-13.html

 

[Guest]

I looked at that from a previous thread. However, I guess the difference
between that and mine is that in mine the date and time fields are seperate
fields. There is a date field selected and there is a time field selected.
They are not joined together. Any thoughts??

 

[Guest]

okay, I am an idiot! Once I combined the date field and the time fields into
a single field, it worked like a dream. go figure..lol Problem resolved.
Thanks bunches and bunches for your help.

Brian