hours between dates

  1. J

    Formula to distinguish 'day shift hours' from 'night shift hours'

    Hi everyone, I'm trying to calculate the exact day shift hours and the exact night shift hours. The day hours are from 9:00 to 18:00 and the night shift hours are from 18:00 to 9:00. I just can't get any formula to do what I need it to do. I would really appreciate any help on this, I'm going...
  2. B

    Difference in time in two cells

    Hello all. I need help finding the difference between two times entered in C19 (start time, formatted to time) and F19 (end time, formatted to time). I need to split the results in two different cells, AI19 (hours) and AL19 (minutes). There red will be a lot times when the users time is...
  3. T

    Calculate Hours between two dates without weekend

    Hi fellows. I have two dates like following 2019-03-07 21:00 2019-03-18 11:00 I would like to know how many hours between these two dates omitting Saturday and Sunday Kindly guide me for the formula to get results Kind Regards

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top