• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 175
  • Last Modified:

EXCEL: Computing Total Time

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!  

 Example
0
itsmevic
Asked:
itsmevic
  • 4
  • 2
2 Solutions
 
zorvek (Kevin Jones)ConsultantCommented:
The easiest solution is to subtract one from the other:

=C3-B3

Kevin
0
 
Patrick MatthewsCommented:
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
 
zorvek (Kevin Jones)ConsultantCommented:
If the times can cross over midnight then:

=MOD((C3-B3),1)

Kevin
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
zorvek (Kevin Jones)ConsultantCommented:
Mr. Patrick, even with a date the subtraction will still work ;-)
0
 
Patrick MatthewsCommented:
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
 
zorvek (Kevin Jones)ConsultantCommented:
Yes, that would be a problem.
0
 
itsmevicAuthor Commented:
Awesome input, thank you everyone!
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now