Need formula for Elapsed Time (negative values, times after midnight)

rgsanchez

New Member
Joined
Dec 1, 2016
Messages
11
Hello,
I need to calculate how minutes late/early a train arrived (elapsed time) by comparing the scheduled arrival time with the actual arrival time. I have tried many different ways of doing this, but none of the ways seem to work for all four scenarios I've encountered with the data. Please note that I must keep the 1990 date system (Windows default). Also, I need to keep the results in numeric values that I can use to do future calculations with. The same formula must work for all four scenarios. Please see below (I don't know how to attach the actual Excel sheet).

ScenarioScenario DescriptionMinutes Early/LateScheduled
Train Arrival
Actual
Train Arrival
1Train was late 7.008:58 AM9:05 AM
2Train was early (2.00)5:50 PM5:48 PM
3Train was exactly on-time (0.00)7:07 PM7:07 PM
4Train arrived after midnight. (1,383.00)11:03 PM12:00 AM
Scenario 4 should result in 57 minutes late, not 1,383 minutes early.
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
Thanks, Toadstool. I am new to Mr. Excel and I accidentally posted in the wrong forum at first. I will delete this post above.
 
Upvote 0

Forum statistics

Threads
1,213,527
Messages
6,114,148
Members
448,552
Latest member
WORKINGWITHNOLEADER

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top