Microsoft Office Forums Rounding Up or Down depending on Start & End time
 Register FAQ Search Today's Posts Mark Forums Read

#1
06-20-2016, 04:27 PM
 richardst Windows 10 Office 2010 64bit Novice Join Date: Jun 2016 Posts: 3
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
 TimeCard.xlsx (118.1 KB, 4 views)
#2
06-20-2016, 06:58 PM
 macropod Windows 7 64bit Office 2010 32bit Administrator Join Date: Dec 2010 Location: Canberra, Australia Posts: 19,197

Cross-posted at: http://www.mrexcel.com/forum/excel-q...-end-time.html
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
#3
06-20-2016, 10:13 PM
 xor Windows 10 Office 2016 Expert Join Date: Oct 2015 Posts: 1,005

Maybe like the attached.
Attached Files
 TimeCard_2.xlsx (92.6 KB, 7 views)
#4
06-21-2016, 05:39 PM
 richardst Windows 10 Office 2010 64bit Novice Join Date: Jun 2016 Posts: 3

I no longer want anything to do with this site. Please remove me from your member listing

Last edited by macropod; 05-01-2017 at 06:04 AM. Reason: Offensive content deleted
#5
06-21-2016, 06:03 PM
 macropod Windows 7 64bit Office 2010 32bit Administrator Join Date: Dec 2010 Location: Canberra, Australia Posts: 19,197

That isn't how forums work. That said, given your discourteous, belligerent and ungrateful attitude both here and at MrExcel, I doubt anyone at either forum will be having too much more to do with you. Thread closed.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post rtuttle Project 9 04-15-2016 06:18 AM ellebb85 Excel Programming 0 01-17-2016 02:50 AM Haha88 Excel 1 10-13-2015 11:30 PM rdperry11 Excel 4 02-24-2015 09:35 PM mtrborges Word VBA 2 02-08-2015 11:35 PM

All times are GMT -7. The time now is 07:30 AM.

 -- Default Style -- Mobile Style Contact Us - Privacy Statement - Top