#1
|
|||
|
|||
Calculate time over two dates
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 |
#2
|
|||
|
|||
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)) |
#3
|
|||
|
|||
Try this in E2 and drag down
=IF(C2="","",ABS((C2-A2)+(C2<A2))*1440) |
#4
|
|||
|
|||
Thank you so much
|
Tags |
calculate ti timeme, date, time |
Thread Tools | |
Display Modes | |
|
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 |