Excel Formula - Help Please!

[GE90]

I just about have the hang of the basics, but stuck on the following!

IF CELL1 IS GREATER THAN 90    THEN I WANT THIS CELL TO BE CELL2 PLUS 15 MINUTES

CELL2 is formatted as hr:mm

Any guidance appreciated!

PS, Also stuck on calculating in a cell the hours and minutes difference (or even just minutes) between two cells set at hr:mm am/pm!

Thanks!

[richtung]

Im just a basic user of excel so my help will be limited.

In CELL1, i presume the value in there is a time? If so, preume the format is displayed in number of mins - so 1hr is "60" and 2 hours is "120"?

Rich

[chungster]

Put in Cell3 00:15 as 15 mins.  Then in Cell4, enter the formula =if(cell1>90,Cell2+Cell3),0) you can replace the 0 at the end to be whatever answer you want for cell1 being below 90.

As for working the out the difference between 2 times that's in AM/PM, simply do 2nd time minus 1st time to get the difference. Then in next 2 cells, use the function =hour and =minute against the cell with the time difference. This will give you the hours and minutes in number form.

That should work I think! 

[Wild Bean]

Put in Cell3 00:15 as 15 mins.  Then in Cell4, enter the formula =if(cell1>90,Cell2+Cell3),0) you can replace the 0 at the end to be whatever answer you want for cell1 being below 90.

As for working the out the difference between 2 times that's in AM/PM, simply do 2nd time minus 1st time to get the difference. Then in next 2 cells, use the function =hour and =minute against the cell with the time difference. This will give you the hours and minutes in number form.

That should work I think! 

Geek !

[GE90]

Put in Cell3 00:15 as 15 mins.  Then in Cell4, enter the formula =if(cell1>90,Cell2+Cell3),0) you can replace the 0 at the end to be whatever answer you want for cell1 being below 90.

As for working the out the difference between 2 times that's in AM/PM, simply do 2nd time minus 1st time to get the difference. Then in next 2 cells, use the function =hour and =minute against the cell with the time difference. This will give you the hours and minutes in number form.

That should work I think! 

Thanks all, but I have completely failed!!! 6 hrs on a 'simple' spreadsheet! I have had to ask chungster whether I could send him the spreadsheet for his help!

[Smudgster]

If you need help pm me and I will give my email address. I can sort that for you no problem but its easier to see the spreadsheet!!!

[GE90]

Cheers, did you not get my email earlier? Thanks