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

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