Hours between two dates and times

0
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

[vc_text_separator title=”Tools you’ll need” title_align=”separator_align_center” align=”align_center” color=”blue” border_width=”2″]

LEAVE A REPLY

Please enter your comment!
Please enter your name here