Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-22-2017, 10:57 AM
Diver Diver is offline Calculate time over two dates Windows 10 Calculate time over two dates Office 2013
Novice
Calculate time over two dates
 
Join Date: Feb 2017
Posts: 21
Diver is on a distinguished road
Default Calculate time over two dates


Hi

Please help i want to recorde/calculate time in minutes also when i pass midnight or pass from one date to another.

Example: i start at 23:00 and stop 03:00
Attached Files
File Type: xlsx Time.xlsx (8.6 KB, 12 views)
Reply With Quote
  #2  
Old 07-22-2017, 08:50 PM
Logit Logit is offline Calculate time over two dates Windows 10 Calculate time over two dates Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

If you can use an input of regular time (12 hr instead of 24 hr), the attached will do what you want, using this formula :

Code:
=IF(A2="","",MOD((TIMEVALUE(TRIM(SUBSTITUTE(SUBSTITUTE($B2,"pm"," pm"),"am"," am"))))-(TIMEVALUE(TRIM(SUBSTITUTE(SUBSTITUTE($A2,"pm"," pm"),"am"," am")))),1))
Attached Files
File Type: xlsx Time Total.xlsx (9.2 KB, 17 views)
Reply With Quote
  #3  
Old 07-22-2017, 09:30 PM
NoSparks NoSparks is offline Calculate time over two dates Windows 7 64bit Calculate time over two dates Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

Try this in E2 and drag down

=IF(C2="","",ABS((C2-A2)+(C2<A2))*1440)
Reply With Quote
  #4  
Old 07-22-2017, 11:31 PM
Diver Diver is offline Calculate time over two dates Windows 10 Calculate time over two dates Office 2013
Novice
Calculate time over two dates
 
Join Date: Feb 2017
Posts: 21
Diver is on a distinguished road
Default

Thank you so much
Reply With Quote
Reply

Tags
calculate ti timeme, date, time

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate time over two dates how to calculate average time aymanharake Excel 6 02-17-2017 04:22 PM
Calculate time over two dates Need a formula to calculate turnaround time Rockitman31 Excel 9 09-07-2015 09:41 AM
Is this possible? - Calculate and Display the date range between 2 specific dates Premier-UK Excel 2 08-18-2014 05:43 AM
Calculate time over two dates IF Formula to calculate dates Sophie1 Excel 2 04-23-2014 07:19 AM
Calculate time over two dates How to get cells to calculate time? jrasche2003@yahoo.com Excel 2 02-09-2007 07:10 AM

Other Forums: Access Forums

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


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