Hi all
Just wondered if anyone could help with a small issue.
I am using MS Excel to track my work hours, I have a table with start time, finish time and break, then total hours.
Say for example I put start time in A1 Finish time in A2 Break in A3 and total hours in A4
I currently have the sum in total hours =IF(A2<A1,A2+1)-A1, this gives me the answer in hours worked, but im unsure how to take away break time, so if I put down a 30 min break, I need to remove that figure from the hours worked, but if I type -A3 (break column) or -30, i am left with #####
Does anyone have any clues if this is possible please?
Kind regards
Jason
Just wondered if anyone could help with a small issue.
I am using MS Excel to track my work hours, I have a table with start time, finish time and break, then total hours.
Say for example I put start time in A1 Finish time in A2 Break in A3 and total hours in A4
I currently have the sum in total hours =IF(A2<A1,A2+1)-A1, this gives me the answer in hours worked, but im unsure how to take away break time, so if I put down a 30 min break, I need to remove that figure from the hours worked, but if I type -A3 (break column) or -30, i am left with #####
Does anyone have any clues if this is possible please?
Kind regards
Jason
