Calculating Time Differences

If you want to calculate time differences, for example, the time between 23:30 and 01:10 in the same night, use the following formula:

=(B2<A2)+B2-A2

बाद का समय B2 है तथा पहले का समय A2 है. इस उदाहरण का परिणाम होगा 01:40 या 1 घंटा 40 मिनट.

In the formula, an entire 24-hour day has a value of 1 and one hour has a value of 1/24. The logical value in parentheses is 0 or 1, corresponding to 0 or 24 hours. The result returned by the formula is automatically issued in time format due to the sequence of the operands.