Nested IF Formulas with Times not caclulating correctly
Closed
MAUTUMNS
Posts
2
Registration date
Friday March 29, 2013
Status
Member
Last seen
March 29, 2013
-
Mar 29, 2013 at 02:17 PM
Kevin@Radstock Posts 42 Registration date Thursday January 31, 2013 Status Member Last seen April 26, 2014 - Mar 29, 2013 at 02:56 PM
Kevin@Radstock Posts 42 Registration date Thursday January 31, 2013 Status Member Last seen April 26, 2014 - Mar 29, 2013 at 02:56 PM
Related:
- Nested IF Formulas with Times not caclulating correctly
- Mouse not pointing correctly - Guide
- Times attack - Download - Children
- How many nested if statements in excel - Guide
- Little alchemy formulas - Guide
- Spreadsheet formulas - Guide
2 responses
MAUTUMNS
Posts
2
Registration date
Friday March 29, 2013
Status
Member
Last seen
March 29, 2013
Mar 29, 2013 at 02:20 PM
Mar 29, 2013 at 02:20 PM
I should add that this is what I currently have for my formula:
IF(Q15="NO","NA",IF(P15<60,MINUTE(P15),IF(P15>60,SUM(MINUTE(P15+60)))))
I hope I am missing something obvious as it seems to work correctly for minutes less than 60.
IF(Q15="NO","NA",IF(P15<60,MINUTE(P15),IF(P15>60,SUM(MINUTE(P15+60)))))
I hope I am missing something obvious as it seems to work correctly for minutes less than 60.
Kevin@Radstock
Posts
42
Registration date
Thursday January 31, 2013
Status
Member
Last seen
April 26, 2014
9
Mar 29, 2013 at 02:56 PM
Mar 29, 2013 at 02:56 PM
Hi MAUTUMNS
Not sure if I understand correctly!
=IF(StartB<EndA,(EndA - StartB)*1440,"")
Is something that you can work with!
Kevin
Not sure if I understand correctly!
=IF(StartB<EndA,(EndA - StartB)*1440,"")
Is something that you can work with!
Kevin