Forum Discussion
Calculate Difference on Time
I'd like to ask for help regarding a #VALUE error I am receiving when subtracting time duration. End Time - Start Time. I use the simple formula =D4-C4 but the error shows on E4 cell where the formu...
Hi Deleted
From your screenshot it looks like your times are aligned to the left of the cell which indicates they have been entered as text.
Change the cell format to General and try typing them in again. It should then work
Wyn
Hi Deleted
From your screenshot it looks like your times are aligned to the left of the cell which indicates they have been entered as text.
Change the cell format to General and try typing them in again. It should then work
Wyn
Amazing! That worked! Thank you for the help Wyn Hopkins