Microsoft Office Forums

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

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default
Try this in E2 and drag down

=IF(C2="","",ABS((C2-A2)+(C2<A2))*1440)
Reply With Quote
 

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
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 07:33 AM.

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