IF statement for hours/mins
 

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.

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

Cheers
JulieD

"k f h" wrote in message
...
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.

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" wrote:

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

Cheers
JulieD

"k f h" wrote in message
...
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.

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


"k f h" wrote in message
...
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" wrote:

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

Cheers
JulieD

"k f h" wrote in message
...
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.

Hi JulieD,

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

Thanks,

kfh.


"JulieD" wrote:

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


"k f h" wrote in message
...
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" wrote:

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

Cheers
JulieD

"k f h" wrote in message
...
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.

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

"k f h" wrote in message
...
Hi JulieD,

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

Thanks,

kfh.


"JulieD" wrote:

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


"k f h" wrote in message
...
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" wrote:

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

Cheers
JulieD

"k f h" wrote in message
...
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.