What formula do I use to subtract the total of hours from 'Time In' and 'Time Out' columns in the workbook I attached? I tried =E5:E24-D5:D24, but that wouldn't work.
What formula do I use to subtract the total of hours from 'Time In' and 'Time Out' columns in the workbook I attached? I tried =E5:E24-D5:D24, but that wouldn't work.
MaybeFormula:Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Or perhapsFormula:Please Login or Register to view this content.
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks