I usually work from 3pm to 1am. I can't seem to find out how to make google sheets find the correct duration between those times. I know the correct duration is 10 hours, but no matter what I do google sheets comes up with either 16hours and 14 hours.
1
-
can you share a copy of your sheet? – user0 Aug 21 '18 at 20:14
Add a comment
|
- try to format it as Automatic, Time or Custom Time instead of Duration
- or you can format it as Duration if you add date 31/12/1899 before your time
-
1Thanks @user0 I had my A and B cells formatted as time, and the C cell as duration. I thought it would have worked, but it would always count from 1am to 3pm, instead of 3pm to 1am. It didnt even occur to me to try to use Automatic. Thanks again! – Ovcheric Aug 22 '18 at 1:52