I am trying to give a time value to blank cells containing an existing formula; this formula enters the value I want .....
=IF(ISBLANK(E5),"8:00",MOD(E5-D5,1)
......but if I drag the formula down through 5 cells and use the sum function to add the totals it returns 0:00 instead of the 40:00 I was expecting.
I am a new user and until this point I was managing okay by watching the online tutorials but this one has got me stuck so any help would be appreciated.
=IF(ISBLANK(E5),"8:00",MOD(E5-D5,1)
......but if I drag the formula down through 5 cells and use the sum function to add the totals it returns 0:00 instead of the 40:00 I was expecting.
I am a new user and until this point I was managing okay by watching the online tutorials but this one has got me stuck so any help would be appreciated.