I've started a spreadsheet which logs workers shift patterns shown in rotary (24 Hr) shifts.
What I'm trying to do is to convert the hours/mins to either a number or currency value.
An example is as follows :-
Start Finish Hrs Cost ?
6:00 14:00 8:00
6:00:00 AM 2:00:00 PM =SUM(AJ14-AI14) ??????
Any hel pwould be gratefully received !
Regards,
Reynard