Results 1 to 3 of 3

Thread: [excel] How to remove non-shift hours from computation

Threaded View

  1. Oct 24th, 2012, 03:00 PM #1
    a-a06
    a-a06 is offline

    Thread Starter
    Addicted Member a-a06's Avatar
    Join Date
    Dec 2007
    Location
    P.H.
    Posts
    147

    [excel] How to remove non-shift hours from computation

    Hi everyone,

    I'm newbie to excel. I'm trying to create a simple time tracker that can track how many minutes/hours a transaction has been complete. It's easy as subtracting cells *1440 but I needed a formula that will remove the time/hours that we're not here in the office.

    Example: our shift starts at 8pm and end at 5am and we receive a transaction 4:50am but they we're able to finish it on the next shift 8:30pm. How can I remove 6am-7:59pm on computing the total minutes it has been done.

    I do hope I make sense, really such a newbie on these stuffs. Thanks!
    Last edited by a-a06; Oct 24th, 2012 at 03:21 PM. Reason: title
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Tags for this Thread

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width