Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I have a simple spreadsheet for determining the hours and minutes that an
employee works during a pay period. The current result is formatted like "38:45" meaning 38 hours and 45 minutes. My payroll software needs the time worked in decimal format (i.e., 38.75). Can someone please show me how I would use an Excel formula to covert hours and minutes to hours and fraction of hours. Thank you. -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~ Greg Maxey - Word MVP My web site http://gregmaxey.mvps.org Word MVP web site http://word.mvps.org ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Time difference calculations, daylight savings time, Excel | Excel Discussion (Misc queries) | |||
Overlapping time calculations and automatic time updates | Excel Worksheet Functions | |||
time calculations | Excel Worksheet Functions | |||
convert time imported as text to time format for calculations | Excel Worksheet Functions | |||
Time calculations | Excel Discussion (Misc queries) |