We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Date and time timediff in minutes. [closed]

asked 2018-03-16 08:26:32 +0200

guntun gravatar image

25.01.2018 TIme: 14.28

13.03.2018 Time 10.24

How to get the difference in minutes between these two points of time to a cell ?


edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2021-05-01 01:24:31.208902

2 Answers

Sort by » oldest newest most voted

answered 2018-03-16 11:07:35 +0200

Lupp gravatar image

updated 2018-03-23 09:28:20 +0200

There are two very different concepts of time:

The scientific / engineering time is an inexorably running measurable, well defined beyond stubborn decrees.
(Durations are differences of two values of this kind taken under certain conditions.)

The TimeOfDay, completely (but differently by country ...) decreed by authorities.

Taking your question literally, and assuming your DateTimeValues are located in A1 and B1 respctively, you get the difference displayed in minutes by =B1-A1 used in a cell set to the 'Numbers format code
[m]" min".

To get the difference as a number of minutes you need to use =(B1-A1)*1440 because the predefined (pseudo) unit of time in spreadsheets is the day (1 d), and the ordinary day has 60*24 = 1440 minutes.

Please stay aware of the facts that
-1- Real days differ in length, this specifically applicable to decreed days. (Think of the DST hokum.)
-2- You need to know and to apply the concerned decrees thoroughly if you want reliable results (on the resolution level of minutes!).
-3- There is no sense in calculating differences for time values taken in different time zones without specific measures or in very specific situations.

edit flag offensive delete link more

answered 2018-03-16 21:06:16 +0200

guntun gravatar image

Thank you very much !!

edit flag offensive delete link more


Please use a comment for comment not an answer, and If the answer solves your question please tick the ✔.

m.a.riosv gravatar imagem.a.riosv ( 2018-03-16 23:49:44 +0200 )edit

Question Tools

1 follower


Asked: 2018-03-16 08:26:32 +0200

Seen: 14,437 times

Last updated: Mar 23 '18