Hi All,
I have an excel sheet where I want to have a time from cell and a time too cell and want to automatically work out the duration.
IE
Time From 08:20
Time To 09:50
Duration 01:30:00
I have worked out how to do the duration using the formula:-
TEXT(F5-C5,"h:mm:ss")
However I want the duration cell to be blank until both the Time From and Time To are filled in...
I have tried a formula along the lines of
if (isblank (C5+F5) but this is not working and I am struggling, is there some formula i can write to check if both cells are not blank..
Thanks.
I have an excel sheet where I want to have a time from cell and a time too cell and want to automatically work out the duration.
IE
Time From 08:20
Time To 09:50
Duration 01:30:00
I have worked out how to do the duration using the formula:-
TEXT(F5-C5,"h:mm:ss")
However I want the duration cell to be blank until both the Time From and Time To are filled in...
I have tried a formula along the lines of
if (isblank (C5+F5) but this is not working and I am struggling, is there some formula i can write to check if both cells are not blank..
Thanks.