Seconds between two dates and times

How to calculate the seconds between two dates and times in excel

0
1660
How to calculate the seconds between two dates and times in excel

You can easily calculate the seconds between two dates and times in excel. All you have to do is enter the following into the formula bar

=((finish_date+finish_time)-(start_date+start_time))*24*60*60

Example

Below is a worked example for how to calculate the seconds between two dates and times in excel

How to calculate the seconds between two dates and times in excel

Here you can see

=((finish_date+finish_time)-(start_date+start_time))*24*60*60

becomes

=((C3+D3)-(A3+B3))*24*60*60

Tools you'll need

LEAVE A REPLY

Please enter your comment!
Please enter your name here