| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Quarter Hour time conversions for timesheet
Users enter a time that needs to be converted to quarters of an hour. For 8
to 22 minutes past the hour = x:15, for 23-37minutes past the hour = x:30 For 38 to 52 minutes past the hour =x:45 and For 53 minutes before the hour to 7minutes past the hour = x:00. Many may ask Why? Its the way its always been done by hand. Yikes! Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Round time to quarter hour | Excel Worksheet Functions | |||
| How do I round time to the nearest quarter of an hour | New Users to Excel | |||
| how to calculate time start & time finish in quarter hour | Excel Discussion (Misc queries) | |||
| rounding up time to quarter hour increments | Excel Worksheet Functions | |||
| Need to round the time to the nearest quarter hour. Help | Excel Discussion (Misc queries) | |||
Threaded Mode
