how to change cell value to hour

[chop83]

Hi,

I have been given a list with 4 shifts and downtimes and other data. The downtimes are put in as the value like 80, for 80 minutes.
I have made a table and created a Pivot Table.
I got now under Row the Shifts and the downtime under Values.
Shift 1 total 135
Shift 2 total 340
Shift 3 total 100
Shift 4 total 80

Can i change the 135,340,100,80 to 2.25h, 5.6h, 1.66h and 1.33h?
i don`t want to end up with 655 minutes , I just want a total of 10.9h or 10h 54min.

thanks for the help

[LeoTaxi]

Shift 1 / 60 gives 2.25

Kind regards
Leo

[avk]

If your shift time in "A2" i.e. 135
In "B2" enter formula : =A2/1440 & copy down formula upto end.
Go To Format > Customer > in type field enter : hh "h":mm "min"
click ok