how can i subtract time from two different date?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to calculate the time for my timecard at my job. My shift starts at
7:00 PM and finishes on the next date between 4:00AM to 6:00 AM. Iwant to
know the formula to calculate my daily time.
Thanks
 
with start time in A1 and end time in B1

=B1-A1+(B1<A1)

or

=MOD(B1-A1,1)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtracting time...again 2
TIME CALCULATION 5
Calculate elapsed time excluding specific timeframe 10
Calculating time for 3rd shift 4
compute date and time difference 5
I need Time Range to return Value 4
Convert times to text string 3
Calculate After hours 3

Back
Top