convert 8 hours and 45 min in to 8.75 hours.
 

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

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