Excel 2008 : Calculating actual time of day from event timing data.

[edmb]

I have a file with a start time followed by a list of events. Each event is recorded with the length of time (in milliseconds) that elapsed since the previous event. Is there a way to take this data and add it to the start time to get a list of the actual time at which each event occurred? For example, the start time might be 4:23:03 and the first few events might have times like 27896 and 4565. The actual times of each event (rounded to the second) would then be 4:23:31 and 4:23:36. Is it possible to add times in this way?

Thanks.

[shg]

Welcome to the forum.

If A1 contains a time, and B1 contains a value in ms, the =A1+B1/1000/86400 is the sum of the two.