On my spreadsheet I have when I clocked in and when I clocked out, there may be multiple of these such as the line below...
DATE IN OUT IN OUT IN OUT IN OUT time
Wed 1 8:30 13:00 15:30 17:30 6.50
I want to know the formula that I can use that will calulate the total time for me. without haveing to do it manually. I know it's possible, I am just not the best with formulas.
Can you help.
Bookmarks