# Military/24 Hour Time Adding and difference finding

1. ## Military/24 Hour Time Adding and difference finding

I have a spreadsheet with a lot of raw data that I need to separate and make statistics with.

Basic columns are: Name, Event, Time Start, Time End

I need to see how long someone was at an event. I can do this with simple math, but the problem comes that I am using 24 hour clock to do this. The times only come in 30 minute intervals. I have two problems...

1) I need to add the total time someone has been at all of the events.

2) I need to know how long they have been at one event first, including if it starts at 1700 and goes until 0200.

Worth noting is that there are consistently more rows being added by the day or week.
Thanks.

2. ## Re: Military/24 Hour Time Adding and difference finding

In E2 and copy down,

=(DOLLARDE(D2/100, 60) - DOLLARDE(C2/100, 60))/24 + (C2>D2)

Format the result as [h]:mm

3. ## Re: Military/24 Hour Time Adding and difference finding

Thanks a lot.

4. ## Re: Military/24 Hour Time Adding and difference finding

You're welcome, glad it worked for you.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1