Feb 11 2022 10:43 AM
To calculate the total hours worked, I have cells for start time, stop time and hours worked. My formula for hours worked is =TEXT(Stop time - Start time) E.g. 8pm - 2pm = 6 hours worked.
I then want to add the total hours worked; how do I add the value contained in cells that start "=TEXT...)?
Feb 11 2022 10:58 AM
SolutionBetter not to use TEXT and calculate time difference as =MOD(end-start,1)*24 applying General or Number format.
Feb 11 2022 10:58 AM
SolutionBetter not to use TEXT and calculate time difference as =MOD(end-start,1)*24 applying General or Number format.