#1
|
|||
|
|||
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!!! |
#2
|
||||
|
||||
Cross-posted at: http://www.mrexcel.com/forum/excel-q...-end-time.html
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Maybe like the attached.
|
#4
|
|||
|
|||
Remove me from your site
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
|
||||
|
||||
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 [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Start & Finish Date/Time | rtuttle | Project | 9 | 04-15-2016 06:18 AM |
Marking specific cells depending on start and end time entered | ellebb85 | Excel Programming | 0 | 01-17-2016 02:50 AM |
find shift with start and end time | Haha88 | Excel | 1 | 10-13-2015 11:30 PM |
Control Time Calculaiton depending on whether line is running or not. | rdperry11 | Excel | 4 | 02-24-2015 09:35 PM |
Help - Run-time error 91 - VBA for inserting and formatting text depending on style | mtrborges | Word VBA | 2 | 02-08-2015 11:35 PM |