Results 1 to 10 of 10

Difference between two times - thank you!!

Threaded View

  1. #1
    Registered User
    Join Date
    08-09-2005
    Posts
    98

    Difference between two times - thank you!!

    Hello everyone

    I would really appreciate your help

    I have a client who weants to work out the total number of hours (not minutes) between two times. I have managed to do that with no problem using the formula =IF(A2>B2,B2-A2+1,A2+B2). However, this is where the problem starts.

    They want to multiply the number of hours with the number of men on the job, but the answer is wrong, and I cannot understand why. I have checked the formnat of the cell and changed it to see if that is the problem, but without success.

    I have copied it below

    Time in Time out No hours No of Men Total Man Hours
    12:00 03:00 15 2 6
    14:00 18:00 4 7 4


    Any help would be really apprciated

    Thank you
    Lynne
    Last edited by Lynneth; 11-10-2008 at 03:57 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1