View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Google Rocks Google Rocks is offline
external usenet poster
 
Posts: 1
Default 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