Microsoft Office Forums - View Single Post - Calculate time over two dates

Thread: Calculate time over two dates

View Single Post

Old

07-22-2017, 08:50 PM

Logit

Logit is offline

Logit uses Windows 10

Windows 10 Logit uses Office 2007

Logit uses Office 2007

Office 2007

Expert

Join Date: Jan 2017

Posts: 591

Logit is a jewel in the rough

Logit is a jewel in the rough

Logit is a jewel in the rough

Logit is a jewel in the rough

Default

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

Attached Files

Time Total.xlsx (9.2 KB, 19 views)

Reply With Quote