How to deduct time values and get results in Hour : Minutes format

[ThrottleWorks]

Hi,

Please see attached file for details.
I am trying to deduct time values and get time remaining in hours and minute format.
Can anyone please help me in this.

 

[Chihiro]

In your current format...

Something like.
=IF(D4<E4,1+E4-D4,E4-D4)

 

[ThrottleWorks]

Hi @Chihiro sir, thanks a lot for the help. However, I am still not able to get desired result. Could you please help if you get time.

Have a nice day ahead.

 

[Chihiro]

? Your results in column A seems to be off for bunch of examples.

You'll need to explain what date Cut off belongs (today or yesterday).

And NOW portion, should it not include date portion?

I'd suggest you use NOW() in NOW column (instead of trying to extract time portion only).

Then formula in column A becomes...
=IF(E21>D21,E21-TODAY()+D21,TODAY()+D21-E21)

 

[bosco_yip]

Maybe……….

1] In "Time remaining / Elapse" A4, formula copy down :

=TEXT(ABS(B4-C4),IF(B4<C4,"-",)&"[h]:mm:ss")

2] In "Time remaining" D4, formula copy down :

=(B4-C4)*1440

3] Formula Checking (Total min) L4, formula copy down :

=MID(A4,(LEFT(A4)="-")+1,8)*1440

4] See attached file.

Regards
Bosco

 

[ThrottleWorks]

Hi @Chihiro sir, sorry for late reply. I was out of station yesterday.
As of now I am not required to consider 'Date' part of the time value.

My ideal output would as mentioned below.
70 minutes = 1:10 (one hour 10 minutes).

Thanks for the help. Have a nice day ahead.

 

[ThrottleWorks]

Hi @bosco_yip sir, thanks a lot for the help. Your formula seems to be working for me. Will revert with details. Have a nice day ahead.