Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Closed Thread
 
LinkBack Thread Tools Display Modes
  #1  
Old 06-20-2016, 04:27 PM
richardst richardst is offline Windows 10 Office 2010 64bit
Novice
 
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 Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 18,989
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 Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 962
xor is just really nicexor is just really nicexor is just really nicexor is just really nicexor is just really nice
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 Windows 10 Office 2010 64bit
Novice
 
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 Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 18,989
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
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


All times are GMT -7. The time now is 01:01 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft