Calculate Time Difference Between Time In HH:MM
Morning all,
Range A4:A9 contains times (14:00-15:00, 15:00-16:00, 16:00-17:00, 17:00-18:00, 18:00-18:30, 19:00-20:00)
in range B4:B9 i have - (=C4, =C5, =C6, =C7, =C8/2, =C9)
the cell with C8/2 is due to the fact that in Cell A8 the time is only half an hour, the rest are a full hour.
I want to make the formulas in B4:B9 more felxible, as i modify the sheet to fit its purpose, the times in A4:A9 may not always be the same (but will alwyas be either a full hour or a half hour)
The intention is to have a formula in B4:B9 that will see if the times difference is a full hour or a half, if its a full hour then just show me the figure from C, if it is a half hour, show me half of the figure in C.
I thought i could do it by -
Code:
=IF(LEFT(A4,2)-RIGHT(A4,2)=1,C4,C4/2)
but that just gives me a figure of 1.
Which thinking about it was doomed to fail as the RIGHT(A4,2) will only show 2 zeros lol
Any suggestions please?
KR
