Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
#2
![]() |
|||
|
|||
![]()
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. |
#3
![]() |
|||
|
|||
![]()
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. |
#4
![]() |
|||
|
|||
![]()
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. |
#5
![]() |
|||
|
|||
![]()
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. |
#6
![]() |
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
What statement to use? | Excel Worksheet Functions | |||
How do I fix a circular reference in a financial statement? | Excel Discussion (Misc queries) | |||
7+ nested if statement? | Excel Worksheet Functions | |||
Statement | Excel Worksheet Functions | |||
If statement needed | Excel Worksheet Functions |