Home » Forums » Open Source Learning Center » Question and Answer

Subtracting Time

Submitted by Debbie Dies on 26 June, 2015 - 01:06

I am trying to subtract time. I can get the answer if Start time is 8 am and Stop Time is 4 pm. I can't seem to get the right answer though if the shift works night and Start Time is 10 pm and Stop Time is 6 am. Can someone help with how to subtract time when it goes to next day

‹ Help me please - data validation for a row via dropdown in 1 cell AWS Simple Calculator Results to Excel ›
»

including the date

Submitted by Renato Bonfiglio on 30 June, 2015 - 06:31.

The solution i suggest is the following

in cell "A1" --> 29/06/2015 17:00
in cell "A2" --> 30/06/2015 08:00
Result in cell "A3" --> = A2-A1 then format cell "37:30:55" result "15:00:00"

Daes it fit for your need

Regards

»

including the date

Submitted by Renato Bonfiglio on 30 June, 2015 - 05:53.

The solution i suggest is the following

in cell "A1" --> 29/06/2015 17:00
in cell "A2" --> 30/06/2015 08:00
Result in cell "A3" --> = A2-A1 then format cell "37:30:55" result "15:00:00"

Daes it fit for your need

Regards

»