Converting Numbers to Time (A second probelm)

  • Thread starter Thread starter Smonczka
  • Start date Start date
S

Smonczka

Due to several peoples help in this group I learned some very helpful
date/time functions but here is one that has since eluded me...

What I am trying to do it convert...

1/6/1900 22:40:25 to the total number of hours and seconds.

As if the start date was 1/1/1900 00:00:00.

Or in other words I have a
start date of
4/6/2005 11:54:53
End date of
4/7/2005 14:07:00
Total time of
1/1/1900 2:12:07

How do i convert the 1/1/1900 2:12:07 into 26:12:07

Thanks for all your help,
Steve
(e-mail address removed)
 
Bob thank you so much, that worked. But can you explain something to
me. What is the difference between [hh]:mm:ss and [h]:mm:ss. I had
originaly tried [h]:mm:ss and of course as you probably know it didn't
work.

Steve
 
Steve,

That is odd, [h]:mm:ss worked fine for me. The only difference is that with
one h, if you have less than 10 hours, say 8, it will show a 8, whereas with
two h's , it shows as hh. It is all formatting.
 
[h]:mm works fine, the only difference is if hours are in single digits then
[hh] will display a leading zero
 
Back
Top