View Single Post
Old 06-20-2016, 04:27 PM
richardst richardst is offline Windows 10 Office 2010 64bit
Join Date: Jun 2016
Posts: 3
richardst is on a distinguished road
Default Rounding Up or Down depending on Start & End time

I have a spreadsheet that I use to Input a Start Time and End Time in one column and the decimal value to that time in another column.
This is what I use for getting the total hours per day:=IF(D2="","",D2-C2) Pretty simple.
This is what I use to get the Decimal value total hours per day: =IF(D2="","",HOUR(E2)+MINUTE(E2)/60)
My problem is how to round up or down based on the "Conversion Table - Minutes to Decimal Hour". This is a table 1 thur 60 with the decimal value .02 thru 1.0
Lets say your Start time is 7:00 am and End time is 4:11 pm which is 9 hours 11 minutes or (9 hours .18 decimal minutes) which would roundup because its closer to 4:15 than 4:00.. Each 15 minutes which ever is closer.
Don't know if I can post the "Conversion Table" with this post. It is a common table on the internet.
Thanks so much for any help!!!
Attached Files
File Type: xlsx TimeCard.xlsx (118.1 KB, 4 views)