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.

  • can you share a copy of your sheet? – user0 Aug 21 '18 at 20:14
  • try to format it as Automatic, Time or Custom Time instead of Duration

enter image description here

  • or you can format it as Duration if you add date 31/12/1899 before your time

enter image description here

| improve this answer | |
  • 1
    Thanks @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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.