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