Hi all.
Im working on a timesheet and have been using the keyboard shortcut "control, shift,colon" to enter a time stamp in a start time and finish time cell and a final cell to calculate total time.
I decided to use the NOW function to insert a time stamp automatically in the start cell but when I use this formula the calculation for total time returns a result of ########################
The NOW function formula looks like this. =IF(F5<>"",IF(H5="",NOW(),H5),"")
and the total time formula looks like this =IF($J5="YES",(($I5-$H5)-(60/1440)),IF($J5="",($I5-$H5),""))
Im very much a beginner with excel and both of the formulas have been copied from tutorials so if there is a better formula to use please suggest it.
Otherwise, how can i correct this?
Thank you.
Bookmarks