convert a summed time value to hours only

J

Jay

Would like to convert the sum total of time values to hours only.

Example is 286:30:00 convert to 286.5 hours
 
B

Bob Phillips

Multiply by 24 as time is stored as a fraction of 1 day

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
Top