Help with time subtraction

J

JG

This is probably a basic question, but here it is anyway.

The 1st cell I want start time, 2nd cell finish time, 3rd cell will be the
difference in the first to cells in #hours # minutes, or even decimal hours.



| 8:00 AM | 1:30 PM | 5 hrs. 30 min.|


Thanks Jeff
 
K

Ken Wright

=cell2 - cell1, formatted as time for hours/minutes view, or

=(cell2 - cell1)*24 for decimal hours
 
J

JE McGimpsey

One way:

=B1-A1

formatted as an elapsed time.

Since XL stores times as fractional days, to get decimal hours multiply
the difference by 24:

=(B1-A1)*24
 

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

How to enter start and end date/time in excel based on some specific value. 7
Subtracting time...again 2
Converting standard time to decimal time 2
Calculate Face Time 4
Help with formula 1
Time Calculated minus breaks & lunch 2
Need help with Time 2
Show hours worked or Text "Day Off" 8

Top