Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have created a spreadsheet for keeping track of work hours. I have a
calculation already for hours worked but need to be able to convert 7:45 to 7.75, 6:15 to 6.25, 5:30 to 5.5, etc... We are only allowed those three additions (.25, .5, .75) to whole numbers. Tried the dividing by 24 thing... not the answer I need. Columns a time in, time out, total hours (which is what needs to be converted). Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
convert a summed time value to hours only | Excel Discussion (Misc queries) | |||
How do I convert more than 24 hours time to decimal? | Excel Discussion (Misc queries) | |||
How do I convert time listed in hours(e.g. 170:41:19) to seconds? | Excel Worksheet Functions | |||
convert military time to regular hours | Excel Worksheet Functions | |||
Convert hours and minutes in time format into fractions of hours.. | Excel Worksheet Functions |