i was wondering if some one could help me with the following problem and thanks in advance
<colgroup><col width="72" span="17" style="width:54pt"> </colgroup><tbody>
</tbody>
i have been tasked to fill out the following sheet i hope i can explain it to you:
i am looking for a formula that will out this sheet for me
for example 1 some one starts at 22:10 so in the time column i have to enter in 00:10 mins from 22:00-23:00
they finish at 6:00 so i have to enter in 1:00 in the column 05:00-06:00
all the rows in between have 01:00 in them as they are at work
i have thousands of these lines to fill out and was wondering if there was a formula to help me with this preferably not VBA
Again thanks in adavance if this is possible
TIME | 20:00 | 21:00 | 22:00 | 23:00 | 00:00 | 01:00 | 02:00 | 03:00 | 04:00 | 05:00 | 06:00 | 07:00 | 08:00 | |||
21:00 | 22:00 | 23:00 | 00:00 | 01:00 | 02:00 | 03:00 | 04:00 | 05:00 | 06:00 | 07:00 | 08:00 | 09:00 | ||||
START | FINISH | |||||||||||||||
22:10 | 06:00 | 00:10 | 01:00 | 01:00 | 01:00 | 01:00 | 01:00 | 01:00 | 01:00 | |||||||
20:25 | 07:20 | 00:25 | 01:00 | 01:00 | 01:00 | 01:00 | 01:00 | 01:00 | 01:00 | 01:00 | 01:00 | 01:00 | 00:20 |
<colgroup><col width="72" span="17" style="width:54pt"> </colgroup><tbody>
</tbody>
i have been tasked to fill out the following sheet i hope i can explain it to you:
i am looking for a formula that will out this sheet for me
for example 1 some one starts at 22:10 so in the time column i have to enter in 00:10 mins from 22:00-23:00
they finish at 6:00 so i have to enter in 1:00 in the column 05:00-06:00
all the rows in between have 01:00 in them as they are at work
i have thousands of these lines to fill out and was wondering if there was a formula to help me with this preferably not VBA
Again thanks in adavance if this is possible