View Full Version : Numeric Data in Cell and Convert to Minutes


uneek78
04-08-2009, 09:50 AM
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
04-09-2009, 04:50 AM
Sure!

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

uneek78
04-09-2009, 05:14 AM
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
04-09-2009, 05:15 AM
Change the format from a date to a number, and then see what you get.

uneek78
04-09-2009, 05:16 AM
I just figured it out when your REPLY email came through..........lol! THANKS A BUNCH!!!!

DanWall
04-09-2009, 05:37 AM
No worries,

Glad I could help.