Time formatting

[Fred Holmes]

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

 

[Bob Phillips]

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

--

HTH

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