How to deduct time and get results in minutes.

[ThrottleWorks]

Hi,

I have values as cut-off ‘22:30:00’ and now ‘11/05/2017 15:00:00’. I am trying to deduct NOW from cut-off and get the result in minutes.

In this example, result will be 450.00 minutes. I have tried something similar earlier but somehow not able to do it now.

Can someone please help me in this.

 

[PCosta87]

Hi,

Try multiplying the result by 1440 (which is the same as 24h*60m)
Format the cell as General or Number

 

[ThrottleWorks]

Hi @PCosta87 sir, thanks for the help. However it is not working.
Getting result as 61,726,676 with "=(E2-D2)*1440"

Please attached file for reference.

 

[vletm]

ThrottleWorks
You should have datepart with Your 'Cut Off' too
or 'Now' should have ONLY timepart
What would You expect [C4] 42866,6667- [B3] 0,6558 give result?

 

[PCosta87]

Hi @PCosta87 sir, thanks for the help. However it is not working.
Getting result as 61,726,676 with "=(E2-D2)*1440"

Please attached file for reference.

Like this then (see attached)

 

[ThrottleWorks]

Hi @vletm sir, thanks, my mistake, trying with '=TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW()))'. Please give me some time to check.

 

[SirJB7]

Hi, ThrottleWorks!
I suggest you this formula that takes care of the ymd integer part of Now():
=(A1-RESIDUO(B1;1))*1440 -----> in English: =(A1-MOD(B1,1))*1440
Regards!

 

[vletm]

ThrottleWorks
'=TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW()))' ... hmm?
do You mean?
=NOW()-TODAY()
and be careful with 'negative times'