Numeric Data in Cell and Convert to Minutes

[uneek78]

Can you somehow link calculated data from one cell to appear in another cell in another format?

I have the data in the cell calculating like TEXT(D2-C2,"d:h:mm") which gives time in days/hours/minutes. Is there a way I can make that result show up in another cell in minutes?

 

[DanWall]

Sure!

=day(d2-c2)*(24*60)+hour(d2-c2)*60+minute(d2-c2)

 

[uneek78]

It gave me 12:00am. I was hoping it would put it in all minutes. Lets say, if I had something that totaled to 1 day and 2 minutes. I would get 1442 minutes.

 

[DanWall]

Change the format from a date to a number, and then see what you get.

 

[uneek78]

I just figured it out when your REPLY email came through..........lol! THANKS A BUNCH!!!!

 

[DanWall]

No worries,

Glad I could help.