D
DaveB
In order to calculate overtime I put in daily hours in a single cel
(format 08:30, 11:30 etc), However, in order to automatically transpos
into my overtime claim sheet, I need to split the time i.e cell A1 t
show the 8, and cell B1 to show the 30. By using the formula [H];; i
will "hide" the :30, but I cannot find a way to do the same to the 8
leaving just the 30 (or 45, 15 etc).
1) a way of doing the above will be very much appreciatted.
2) any other format would also be gratefully recieved.
It is impossible to put 8:30 into a cell and run it over consecutiv
cells as the auto reader does not read it
(format 08:30, 11:30 etc), However, in order to automatically transpos
into my overtime claim sheet, I need to split the time i.e cell A1 t
show the 8, and cell B1 to show the 30. By using the formula [H];; i
will "hide" the :30, but I cannot find a way to do the same to the 8
leaving just the 30 (or 45, 15 etc).
1) a way of doing the above will be very much appreciatted.
2) any other format would also be gratefully recieved.
It is impossible to put 8:30 into a cell and run it over consecutiv
cells as the auto reader does not read it