Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2003
    Location
    Mississippi
    Posts
    3

    Talking need help with excel

    I'm trying to make a spreedsheet for temp employees and I can substact 30 mins lunch time can you help me. What I am using is E8 (starting time) = 7:00, E9 (ending time) = 3:30, E10= :30 (lunch) and F9 which I need it to be total hours worked. What my formula so far has is: =TEXT(E9-E8,"h:mm"). How can I minus the 30 mins. for lunch? Can you help me? Thanks,

  2. #2
    Join Date
    Nov 2002
    Location
    San Francisco
    Posts
    251
    check attached sample.....

    I put there two different versions...


    jiri
    Attached Files Attached Files

  3. #3
    Join Date
    Mar 2003
    Location
    Mississippi
    Posts
    3

    Talking

    Thank you so much for your help. I will try it tomorrow at work. Again, thanks. Marisol

  4. #4
    Join Date
    Mar 2003
    Location
    Mississippi
    Posts
    3

    Talking Thanks!!!!!!!!!!!!!!!!!! :-)

    Thank you so much for all your help. After looking at the formulas I was able to use them for the format I need them. You don't know how much I appreciate your help.

Posting Permissions

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