Time Calculation

[robcarr]

I need to use a formula that takes the total minutes and converts it to hours and minutes.

Currently using =sum(a1/60) if a1 contains 190 mins the answer should show 3 hours 10 mins. What it does show is 3.166666667 I would like to format the answer to show as number of hours, then number of minutes with the words hours and minutes against each.

Can anyone help please.

Thanks

 

[Loomah]

Hi Rob
Your ultimate answer may depend on how you want the info displayed at the end of the day but as a starter use
=trunc(A1/60) &
=Mod(A1,60)
in cells B1 & C1 repectively to give you hours in col B & minutes in col C.

I've been off a week but I seem to remember a few date & time solutions cropping up a couple of weeks ago. It may be worth looking for some of them.

;-) If a man says something and there are no women there to hear him, is he still wrong?

 

[xlbo]

Hi - try this'n
If data in mins in A1

=INT(A1/60) & " Hours " & A1-(INT(A1/60))*60 & " Minutes"

If you need to check for single hours and single mins, you'll need an if statement
HTH
~Geoff~