LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change to formulae Emma Hope Excel Worksheet Functions 3 September 5th 05 09:16 PM
Searching TEXT in formulae, rather than results of formulae AndyE Excel Worksheet Functions 1 July 15th 05 10:57 AM
Dynamic formulae - similar to lotus 123 for excel JohnD Excel Discussion (Misc queries) 1 July 5th 05 11:41 PM
Translate excel formulae Helen Excel Discussion (Misc queries) 3 June 16th 05 07:05 PM
XL2002 Clipboard doesn't paste formulae Jonathan Excel Discussion (Misc queries) 2 May 23rd 05 12:17 PM


All times are GMT +1. The time now is 05:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"