[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!:)

Bump... hello :wave:

:(

Can you share some files as example or please ellaborate in detail. Kinda having diff. in understanding what you are trying to say .. :(