View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Virginia Virginia is offline
external usenet poster
 
Posts: 14
Default Convert dd:hr:mn:ss to Decimal number of hours

Hi all, can anyone help with how to convert days/hours/minutes/seconds of
time into a decimal number of hours.

I tried the INT command which I've used before for hours but it only
converts the hours in my original cell??

Thanks