Solved

# EXCEL:  Computing Total Time

Posted on 2011-10-14
163 Views
Last Modified: 2012-05-12
I have a spreadsheet where I enter in my tasks worked.  I'll enter in a start time and then an end time.  Then enter in a total time worked (See the example below)  I'd like to take the first two columns "Time Start" and "Time End" (which are in military time format) and compute the total time in the "Total Time" woked column.  I could do this manually but it would be much easier if it were formulated.  Thanks for you help!

0
Question by:itsmevic
7 Comments

LVL 81

Accepted Solution

The easiest solution is to subtract one from the other:

=C3-B3

Kevin
0

LVL 92

Assisted Solution

Simple formula:

=C3-B3

Of course, that assumes you are not adding a date portion to your start/end times, and that all starts/ends occur on the same day.
0

LVL 81

Expert Comment

If the times can cross over midnight then:

=MOD((C3-B3),1)

Kevin
0

LVL 81

Expert Comment

Mr. Patrick, even with a date the subtraction will still work ;-)
0

LVL 92

Expert Comment

I am well aware that it will work, but it will only work if the correct dates are used.

For example, I have seen instances in the past the start time has a date portion, and the end time does not.  THAT is what I was trying to guard against.

:)
0

LVL 81

Expert Comment

Yes, that would be a problem.
0

Author Closing Comment

Awesome input, thank you everyone!
0

## Join & Write a Comment Already a member? Login.

### Suggested Solutions

Sometimes we don't want to show zeros in our Excel spreadsheets. This is sometimes most evident in our charts. Look at the chart below, all the zero values are visible. I think that all will agree with the fact that zero values are not looking nice …
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

#### 745 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

#### Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!