Formula for time displayed within a staff rota

Try this
In V3 then copied down

=IFERROR((5+AGGREGATE(15,6,COLUMN($C3:$T3)/($C3:$T3<>""),1)-COLUMN($C3)+MOD(INDEX($C3:$T3,AGGREGATE(15,6,COLUMN($C3:$T3)/($C3:$T3<>""),1)-COLUMN($C3)+1),1))/24,"")

In W3 then copied down

=IFERROR((5+AGGREGATE(14,6,COLUMN($C3:$T3)/($C3:$T3<>""),1)-COLUMN($C3)+INDEX($C3:$T3,AGGREGATE(14,6,COLUMN($C3:$T3)/($C3:$T3<>""),1)-COLUMN($C3)+1))/24,"")