MK5 Golf GTI
General => Random Chat => Topic started by: GE90 on March 23, 2013, 02:17:25 pm
-
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!
-
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
-
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! :laugh:
-
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! :laugh:
Geek ! :P
-
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! :laugh:
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!
-
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!!!
-
Cheers, did you not get my email earlier? Thanks