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
|