Help need someone to "translate" formulae
Hi,
I have downloaded a timesheet template from Microsoft downloads. I would
really like to understand how formulae work but I am a complete beginner. I
wonder if some kind soul would "translate" the following formulae for me just
to give me an idea of what's going on (and I do mean complete beginner please
don't assume I know anything, step by little itsy bitsy step please!)
=IF((OR(B12="",B11="")),0,IF((B12<B11),((B12-B11)*24)+24,(B12-B11)*24))
Where B11 = start time and B12 = finish time
=IF(OR(ISTEXT(C12),ISTEXT(C15)),"Error in C12 or C15",(C12+C15))
C12 = answer for above = total hours am
C15 = total hours pm
Many thanks
--
Mifty
|