IF statement for hours/mins

K

k f h

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.
 
J

JulieD

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

Cheers
JulieD
 
K

k f h

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.
 
J

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
 
J

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
 
Top