HI,
is there a way to autocalculate the hours worked between two times in one cell?
For my work roster i am putting the roster with hours on sheet 1 and then on sheet 2 i would like it to calculate the hours worked.
For example sheet 1 may have:
A1 A2
Staff 1 0800-1400
Staff 2 1000-1430
Staff 3 1500-2300
Staff 4 2000-0800
And what i want it to do is auto populate into sheet 2 the following:
A1 A2
Staff 1 6
Staff 2 4.5
Staff 3 8
Staff 4 12
Any ideas would be greatly appreciated.
Thanks
Bookmarks