View Single Post
  #1   Report Post  
Mifty
 
Posts: n/a
Default 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