Backtime

[dbsci]

I need to create a spreadsheet that I can use to backtime. For
instance, the start time is 0:00 and the ending time is 30:00
minutes. There will be ten events of varying lengths....anywhere from
5 seconds to 8 minutes. I need for these events to be deducted from
30:00 minutes so the start time is 0:00. Is it possible to do this?

Thanks,
Doug

 

[JE McGimpsey]

I need to create a spreadsheet that I can use to backtime. For
instance, the start time is 0:00 and the ending time is 30:00
minutes. There will be ten events of varying lengths....anywhere from
5 seconds to 8 minutes. I need for these events to be deducted from
30:00 minutes so the start time is 0:00. Is it possible to do this?

Not sure exactly what you're after, but I'll give it a shot.

Assume that A1 contains 30:00, and that your ten events are in A2:A11.

Then A12 can represent start time:

A12: = A1 - SUM(A2:A11)

Format A12 with Format/Cells/Number/Custom [mm]:ss


If that's not what you're thinking of, post back with more detail.