excel help

[Scott Loven]

20071206_____ 3526
20071206_____ 10130
20071207_____ 232406
I have the following two columns in an excel spread sheet. The first column contains the date (yyyy/mm/dd), the second contains the 24 hour time of day 0:35:26(hh:mm:ss). I want to find out how much time elapsed between events, any suggestions on an easy way to do this?

Thanks
Scott

[Mitchell Andrus]

Have a look in the top menu item: Insert > Function

The drop-down list: Select a category, "most commonly used" may have a function or two for you. This may have to be a 2 step process, 1 for the calendar and 1 for the clock.

From Excel Help:

=INT((B2-A2)*24)Total hours between two times
=(B2-A2)*1440Total minutes between two times
=(B2-A2)*86400Total seconds between two times
=HOUR(B2-A2)Hours between two times, when the difference does not exceed 24.
=MINUTE(B2-A2)Minutes between two times, when the difference does not exceed 60.
=SECOND(B2-A2)Seconds between two times, when the difference does not exceed 60.

There are also websites likely to have plug-in solutions posted by others with the same needs.

I go to: http://www.exceltip.com/exceltips.php?view=category&ID=111

http://www.exceltip.com/st/Calculate_Years,_Months,_Days_elapsed_from_a_certa in_date_in_Microsoft_Excel/390.html

[Greg Cuetara]

Not that I usually do things the easy way in excel but I would break up all your numbers into different columns....hours minutes seconds in different columns and the same with the date then you can just do simple math in a side box to multiply add and subtract etc. to get what you want....you may have to use if statments if you a number is over 60 seconds push it to a minute etc...

[Todd Willhoit]

Scott,
There might be an easier way, but the attached excel file shows one method. The first table was to prove the conversion from data of your type to the proper date/time format. The second table uses your data.

Have a look. Post a reply or PM me if you have any questions.

Good luck!

Todd

[Scott Loven]

Thanks all! Its amazes me the talent and willingness to help among SMCrs!
Thanks all
Scott