Results 1 to 3 of 3

Thread: Time Calculation

  1. #1

    Time Calculation

    Register for a FREE account, and/
    or Log in to avoid these ads!

    Project Start Time 22-04-2015 12:30:00
    Project End Time 24-04-2015 20:30:00

    Shift Start Time 11:00:00
    Shift End Time 21:30:00

    The total time spent on the project is 29 hours but a simple subtraction is not working and is giving me 56 hours as its taking time beyond Shift End Time 21:30:00.

    Any suggestions on how to get this regularized.

  2. #2
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Excel Version
    plz see the file.
    Attached Files Attached Files

  3. #3
    Assuming the start date & time is in A2, and the end date & time is in B2


Posting Permissions

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