Forum Discussion
Time Split
Hi all does anyone know if its possible to put in a start and finish time say 0430 till 0830 and have it split at say 6 am so it will put 1.5 hours in one cell and 2.5 into another?
We have just h...
Hi Bill,
Time in Excel is just a number, 01:00 is equal to 1/24. If you put your 6am value in some cell, E1 in sample, the formula will be like
First part of it is to make correction for overnight shift.
- Thank you very much for the reply, travelling away from home at the moment but will try it out when I get home. Regards Bill
