Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
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

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 12:30 AM.


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