View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default convert 8 hours and 45 min in to 8.75 hours.

Multiply by 24:

A1 = 8:45

=A1*24

Format as GENERAL or NUMBER

--
Biff
Microsoft Excel MVP


wrote in message
...
Hello, all

How can I using microsoft execl convert 8 hours and 45 min (8:45)
into 8.75 hours, i don't know what am I spupposed to do?

Please help me

Thanks

~A