Change to minutes

Hi

Is there an easy way to change dd:hh:mm in to just minutes?
Without working out Day()*24 + Hour()*60 etc

Mick

=MINUTE(A1) would work. But if you don't want to add a column and you don't need to do any calculations with the cell then you can right click the cells, click format cells, select custom from the list and type in m or mm (whichever is more suitable).

The cell will still contain the time but it will just display the minute value.

seasider89
=MINUTE(A1) for a time of 1 day, 9hrs, 37 minutes, 10 seconds gives the answer 37

Pepe
dd:hh:mm was short for days, Hours minutes

I have several people picking daily, i can calculate how many hrs they pick each day, I can calculate how many hours they pick per week, however this often adds up to more than 1 day in time + hours + min
Im trying to see if there is an easy way to calculate total minutes

Try

=A1*1440

Thanks Pepe & ChemistB,
I was missing the [ ] from the custom mm