Time formatting
 

I'm familiar with subtracting start time from finish time to get
elapsed time, and formatting the elapsed time as a time function, to
include d:h:mm for elapsed times of more than 24 hours. But I don't
seem to be able to work out a formating that will, e.g., report 30
hours for the elapsed time for a number 1.25 [days].

Will formatting do it, or do I have to write my own parsing function?

Thanks,

Fred Holmes

Format it as [hh]:mm, this handles more than 24 hours.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Fred Holmes" wrote in message
...
I'm familiar with subtracting start time from finish time to get
elapsed time, and formatting the elapsed time as a time function, to
include d:h:mm for elapsed times of more than 24 hours. But I don't
seem to be able to work out a formating that will, e.g., report 30
hours for the elapsed time for a number 1.25 [days].

Will formatting do it, or do I have to write my own parsing function?

Thanks,

Fred Holmes