convert a summed time value to hours only
 

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

Example is 286:30:00 convert to 286.5 hours

convert a summed time value to hours only
 

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)

"Jay" wrote in message
...

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

Example is 286:30:00 convert to 286.5 hours

convert a summed time value to hours only
 

=A1*24 and format as GENERAL

"Jay" wrote:


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

Example is 286:30:00 convert to 286.5 hours

convert a summed time value to hours only
 

ty

"Jay" wrote:


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

Example is 286:30:00 convert to 286.5 hours