time

  • Thread starter Thread starter Learning
  • Start date Start date
L

Learning

How do I write Excel formula for start 4am, end 12:35 pm, minus 30 minutes
Thanks
Pete
 
XL stores times as fractional days, so one way:

=TIME(12,35,0) - TIME(4, 0, 0) - TIME(0, 30, 0)

another:

A1: 04:00 am
A2: 12:35 pm
A3: =A2-A1-TIME(0,30,0)

format A3 as a time, if necessary.

If the times may span midnight, use

=MOD(A2-A1-TIME(0,30,0),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

Calculate time worked based on start / end times & working hours 3
How to count the time? 1
Excel Catagorise AM or PM 7
Subtract times? 2
Calculate time 10
Calculate difference in Times 13
Time - By 8am the next morning 11
Problem with time formula 1

Back
Top