Hours Calculation

[mohdabrar]

Hello,

I need some help with a split shift calculations. I have the data as below for Split shifts in an excel sheet, is there a formula that I can use to calculate the sum of total hours from 08:00 - 12:00 and then 16:00 - 21:00. Please let me know if I could achieve this by changing the format in the table.

DS

8:00 - 12:00

16:00 - 21:00

Thanks,
Abrar.

 

[Shesil]

Hi Abrar,

Could you please be more specific on your question? Better if you could upload sample sheet.

Thanks
Shesil

 

[Georgiboy]

The simple formula would be:

=(B1-A1)*24

With B1 holding the largest value,

Looking at the sample, you could use a UDF to pull out the times or you can change the layout of your table to get each time in a cell.