Hello,
Trying to calculate the time duration difference between two dates/times with military time and ideally in this format.
Start Day End Day Start Time End Time Time Difference In Seconds
2016-03-31 2016-04-01 23:00:00 01:00:00 7200
Any ideas? I was considering absolute value functions and a variety of things but nothing seems to work right. I would greatly appreciate it!
Justin
=((EndDate+Endtime)-(StartDate+StartTime))*86400
60 sec/min * 60 min/hr * 24 hr/day =86400 sec/day
Last edited by protonLeah; 03-31-2016 at 11:49 PM.
Ben Van Johnson
Hi, welcome to the forum
Agree with Ben...
D Start D End T Start T End Diff
E20=((B20+D20)-(A20+C20))*86400
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks