| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting hundredths
I have a timesheet that calculates hours worked. I'd like to enable the data
entry person to enter the military time in hundredths. My current formula for calculating the hours is: ((F6 (time out)-C6(time in)+(f6<c6))*24. However, our timeclock generates military time in hundreds, i.e... 14:99-21:96. Is there a way to make the timesheet allow the entry of time in hundredths and then calculate the hours? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| converting minus quantities to plus | New Users to Excel | |||
| Converting CSV files into Excel files | Excel Worksheet Functions | |||
| Formatting Time with Hundredths of Seconds | Excel Worksheet Functions | |||
| roundoff when converting text to numbers | Excel Worksheet Functions | |||
| converting dates into numbers | Excel Discussion (Misc queries) | |||
Threaded Mode
