How to convert day, hour, minutes, seconds into Minutes / Seconds

[rush2rajen]

Hi Excel Gurus,

How I can convert day, hour, minutes, seconds into Minutes / Seconds ?


Thanks
Raj

 

[Faseeh]

Your dates are not true dates..

 

[Faseeh]

If your dates are true dates then this should work:

=ABS(A4+B4-(C4+D4))

 

[Deepak]

Hi Excel Gurus,

How I can convert day, hour, minutes, seconds into Minutes / Seconds ?


Thanks
Raj

Check this into F2

=60*24*((C2+D2)-(A2+B2))