Hi All,

I have been given pages and pages of handwritten start and stop times and I have the fun task of finding total run times for said device, over a period of time.

I have no idea how to format this data in a spreadsheet, other than that I should have 3 columns of data:

Date | Start Time | Stop Time

1/1/14 | 1.25am | 3.14am
1/1/14 | 5.23am | 10.48am
3/1/14 | 6.03pm | 1.24am <-- Stopped Next Day!

So I think that having a 4th column called Total On Time which gives Hours run total would be handy to graph.

Can anyone help me get this started? Because I dont know how to format it so that when I do things like 'B3-B2' it gives me a usable answer. And somehow I need to incorporate run times that go past midnight and into the next morning.

Any guidance/advice would be greatly appreciated.