The formula needs to determine the difference between B10 & C10. d10 is to display the difference. I have tried formatting cells to Time but this doesn't work as it returns "Value"
The formula needs to determine the difference between B10 & C10. d10 is to display the difference. I have tried formatting cells to Time but this doesn't work as it returns "Value"
=C10-B10 formatted it as "h" ?
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Hi Dotty
The difference in time: = end_time - start_time.
For your #VALUE error, see the article at Microsoft.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks