Not sure what I am doing wrong,
=IF(B9="both","1:00",IF(B9="SpareCall","0:30"),IF(B9="930","0:30"))
can anyone help me on this ?
its in the test sheet tab
Not sure what I am doing wrong,
=IF(B9="both","1:00",IF(B9="SpareCall","0:30"),IF(B9="930","0:30"))
can anyone help me on this ?
its in the test sheet tab
Untested, but try:Formula:Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Probably needs to beFormula:Please Login or Register to view this content.
But note that the output(s) will be Text, not true Time values.
it works.
1 more question. I need to be able to manually add minutes to the total of k3.
kicker, is it possible to just add 1 number and it be converted to time ?
a10 - header - Addition HOS Minutes
a11 - 7 - would really just like to add 1 digit instead of 0007
a12 - converted result in hh:mm format so I can sum it with the total in k3
Last edited by northernwarrior; 04-08-2022 at 06:33 PM.
Something like:
=K3+TIME(0,1,0)
=K3+TIMEVALUE("00:01:00")
Or:where K1 contains a number (of minutes).Formula:Please Login or Register to view this content.
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks