IF statement for hours/mins

[Guest]

Hi All,

I've been given an exercise requiring an IF function, to show if a cell is
greater than 59 to show it as hours and mins. so 61 would be one hour one
min. I know the easy way is to format the cells to time, but thats not the
exercise.

Thanks,

kfh.

 

[JulieD]

homework? ... how far have you got now ... what specific aspect of this do
you need assistance with

Cheers
JulieD

 

[Guest]

Hi JulieD

Yes homework of sorts, just a fellow tutor ask me if I could do this simply
exercise, silly me said yes it's easy lol. A1=Hours, A2 Minutes, A3 the if
statement if A3 is >59 etc.

Thanks,

kfh.

 

[JulieD]

Hi

don't like to do people's homework for them

didn't really understand your explaination in the last post so this is based
on my understanding of your first post but should give you a start for
manipulating it into different columns etc
=IF(A1>=60,INT(A1/60)& " hours " & MOD(A1,60) & " minutes",A1 & " minutes")

Cheers
JulieD

 

[Guest]

Hi JulieD,

Thanks for your quick response, I think this is beyond me.

Thanks,

kfh.

 

[JulieD]

now i'm not going to believe that for an instant

type out the cells you have in your worksheet in the following format
..........A............B.............C
1......Value......Hours.....Mins

or whatever
also let us know how the current information has been entered - click on it
and choose format / cells and the number tab - what data type

Cheers
JulieD