(Help) Time Sheet total hours worked per day and overall week

Originally Posted by Glenn Kennedy

Why not just use the very simple: =IF(B4="","",(D4-C4)) and make sure formatting is set to h "h "mm "min"

I tried to use that but this seem to not work if the shift hours is for example 6pm till 6am it will now show hours or mins worked it will show as N/A or Nill.

I have attached the full report i am working on (Not Completed), i am still having issues with the hours, once this is working for 1 agent i can then get it working for the rest just having difficulties working out how to code it correctly to work.)

I have put same names and hours on here for an example just to show what i am trying to do.