Calculate time over two dates

Diver · #1 07-22-2017, 10:57 AM

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

Logit · #2 07-22-2017, 08:50 PM

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))

NoSparks · #3 07-22-2017, 09:30 PM

Try this in E2 and drag down

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

Diver · #4 07-22-2017, 11:31 PM

Thank you so much

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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
IF Formula to calculate dates	Sophie1	Excel	2	04-23-2014 07:19 AM
How to get cells to calculate time?	jrasche2003@yahoo.com	Excel	2	02-09-2007 07:10 AM