longbeachdrive
New Member
 Joined
 Sep 1, 2021
 Messages
 3
 Office Version

 365
 Platform

 Windows
I am tracking time for short projects and having trouble with rounding to the nearest quarter hour.
I am not sure why, but sometimes projects that are exactly 15 minutes round up to the next quarter hour and sometimes it remains at 15. I would like projects of 15 minutes or less to bill at 15 minutes, not 30.
Columns A and B are formatted as h:mm AM/PM
The formula in Column C is =B2A2, and Column C is formatted as h:mm.
The formula in Column D is =CEILING(B2A2,1/96), and Column D is formatted as h:mm
Thank you for your help.
I am not sure why, but sometimes projects that are exactly 15 minutes round up to the next quarter hour and sometimes it remains at 15. I would like projects of 15 minutes or less to bill at 15 minutes, not 30.
Columns A and B are formatted as h:mm AM/PM
The formula in Column C is =B2A2, and Column C is formatted as h:mm.
The formula in Column D is =CEILING(B2A2,1/96), and Column D is formatted as h:mm
Thank you for your help.
A  B  C  D  
1  Start Time  End Time  Total Hours Worked  Quarter Hours Worked (rounded up) 
2  4:00 PM  4:15 PM  0:15  0:30 
3  2:00 PM  2:15 PM  0:15  0:15 
4  2:08 PM  2:23 PM  0:15  0:15 