Hours between two dates and times

0
1865
Hopw to calculate hours between two dates and times in excel

You can easily calculate the hours 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

Example

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

Hours between two dates and time

 

Here you can see

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

becomes

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

Tools you'll need

LEAVE A REPLY

Please enter your comment!
Please enter your name here