Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Change to formulae | Excel Worksheet Functions | |||
Searching TEXT in formulae, rather than results of formulae | Excel Worksheet Functions | |||
Dynamic formulae - similar to lotus 123 for excel | Excel Discussion (Misc queries) | |||
Translate excel formulae | Excel Discussion (Misc queries) | |||
XL2002 Clipboard doesn't paste formulae | Excel Discussion (Misc queries) |