Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting total number of hours (24 hours) into days | Excel Discussion (Misc queries) | |||
wages - multiply hours and minutes by number of hours worked | Excel Discussion (Misc queries) | |||
Drivers Hours Timesheet - Calculate Hours Worked on Weekly Basis | Excel Discussion (Misc queries) | |||
Need to convert hours and minutes to hours and tenths. | Excel Discussion (Misc queries) | |||
Convert hours and minutes in time format into fractions of hours.. | Excel Worksheet Functions |