Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
k f h
 
Posts: n/a
Default 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.

  #2   Report Post  
JulieD
 
Posts: n/a
Default

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   Report Post  
k f h
 
Posts: n/a
Default

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   Report Post  
JulieD
 
Posts: n/a
Default

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   Report Post  
k f h
 
Posts: n/a
Default

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   Report Post  
JulieD
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
What statement to use? Paul Excel Worksheet Functions 6 February 13th 05 06:23 PM
How do I fix a circular reference in a financial statement? drjayhawk25 Excel Discussion (Misc queries) 0 February 7th 05 06:19 PM
7+ nested if statement? Turi Excel Worksheet Functions 3 December 20th 04 08:55 PM
Statement lintan Excel Worksheet Functions 1 December 3rd 04 12:31 AM
If statement needed Patsy Excel Worksheet Functions 1 November 4th 04 04:48 PM


All times are GMT +1. The time now is 06:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"