Time calculation

[Chief Ace]

I tried to calculate time using sumif, if, max, min to no avail. Kindly asking for help. I attach a sample file.

Column “F” must total 8 hours of regular work before it can be credited any overtime in Column “G”.

For the Night Differential, if Regular hours fall between the hour of 18:00 thru 06:00 then employees get credited night differential (ie: 15:30 – 18:30 Night differential is 0.5 hours)

For overtime Night differential, employee work at 04:00 – 06:30 then the employee got credited 2 hours of night differential. Thank you in advanced for any help.

 

[NARAYANK991]

Hi ,

More than a week has passed without any reply of substance / consequence.

1. Upload a workbook which has as much data as possible , so that all of the variations are clear.

2. I assume that you want formulae in columns F , G , H and I.

Explain with at least some examples what the expected outputs in these 4 columns will be , especially for those cases where the times span two dates i.e. where there is a crossover at midnight.

Narayan