Calculate time durations for a roster, and indentify the earliest and latest times

i have to record time durations for a roster that starts at 07:00 and ends 06:00. please see attached sheet.


I NEED A FORMULA TO POPULATE THE "START" AND "END" COLUMN

mANY THANKS IN ADVANCE

I AM CONSIDERING THIS PARTICULAR LAYOUT BUT IT IS NOT SET IN STONE

Hi bajdr47

Not sure what you mean!

Pl see the attached file.

Sorry Gentlemen,

The roster starts at 07:00 and ends 24hrs later 06:00.
i need to read the time order from 07:00-06:00, not 00:00 to 24:00.
Also the start and end time will not always start or end on the latest or earliest time

Regards

Baj

Sorry about this,

i am badly stuck in the sheet attached "ROSTER" i need to examine an indeterminate number of time periods and indentify the earliest and latest time ie EARLIEST = STARTTIME and the LATEST ENDTIME. the difficulty is that the time has to be calculated where the earliest time is 07:00 and the latest time is 06:00. As the Roster starts at 07:00 not at midnight

Sorry again,

i hope that this example is easier to understand.

Regards

baj

In the START and END column, i have to manually input the times by checking Cloumns B E and H, i was wondering if there is a formula that will automate the selection in Column J and K

Sorry SHG,

the tasks come in from job sheets, and i don't have control of the inputting process.

Sorry that should have read 08:00

---------- Post added at 08:28 PM ---------- Previous post was at 08:25 PM ----------

Dont always have my glasses on....But i need to always have my glasses on

Many thanks SHG,

There is a problem if any of the tasks are left empty, i adapted your formula as below, it seems to be ok.
=MIN(IF(C4="",0,MOD(C4-"7:00",1)),IF(F4="",0,MOD(F4-"7:00",1)),IF(I4="",0,MOD(I4-"7:00",1)))+"7:00" IS this OK.or would you have altered it differently.
If i could be so bold to ask, but i understand in principle how the MOD function works, but would you mind explaining about the use of the 07:00 and particularly the double quotes.

Again you assistance is very much appreciated

BAJ

SHG

Sorry but how should i record a task that ends at the close of the shift eg 04:00 - 07:00 It doesn't seem to register.

Kind Regards

BAJ