Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Calculate time over two dates
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
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: 591
Logit is a jewel in the roughLogit 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, 19 views)
Reply With Quote
Reply

Tags
calculate ti timeme, date, time

« Previous Thread | Next Thread »


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 06:08 PM.

Contact Us - Privacy Statement - Top

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