Microsoft Office Forums Rounding Up or Down depending on Start & End time

Go Back   Microsoft Office Forums > >

Closed Thread
 
Thread Tools Display Modes
  #1  
Old 06-20-2016, 04:27 PM
richardst richardst is offline Rounding Up or Down depending on Start & End time Windows 10 Rounding Up or Down depending on Start & End time Office 2010 64bit
Novice
Rounding Up or Down depending on Start & End time
 
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)
  #2  
Old 06-20-2016, 06:58 PM
macropod's Avatar
macropod macropod is offline Rounding Up or Down depending on Start & End time Windows 7 64bit Rounding Up or Down depending on Start & End time Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,533
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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
[MS MVP - Word]
  #3  
Old 06-20-2016, 10:13 PM
xor xor is offline Rounding Up or Down depending on Start & End time Windows 10 Rounding Up or Down depending on Start & End time Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,029
xor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of light
Default

Maybe like the attached.
Attached Files
File Type: xlsx TimeCard_2.xlsx (92.6 KB, 7 views)
  #4  
Old 06-21-2016, 05:39 PM
richardst richardst is offline Rounding Up or Down depending on Start & End time Windows 10 Rounding Up or Down depending on Start & End time Office 2010 64bit
Novice
Rounding Up or Down depending on Start & End time
 
Join Date: Jun 2016
Posts: 3
richardst is on a distinguished road
Angry 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  
Old 06-21-2016, 06:03 PM
macropod's Avatar
macropod macropod is offline Rounding Up or Down depending on Start & End time Windows 7 64bit Rounding Up or Down depending on Start & End time Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,533
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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]
Closed Thread

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Rounding Up or Down depending on Start & End time 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
Rounding Up or Down depending on Start & End time find shift with start and end time Haha88 Excel 1 10-13-2015 11:30 PM
Rounding Up or Down depending on Start & End time 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


All times are GMT -7. The time now is 05:12 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft