View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 380
Default 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