One way:

XL stores times as fractional days, so all you need to do is subtract,
and format the resulting cell as a time:

A1: <start time
B1: <end time
C1: =B1-A1

Since times "roll over" at midnight, if your times span midnight, you
need to add 1 (for 1 day) to the "later" time. You can use XL's implicit
coercion of TRUE/FALSE to 1/0:

C1: =B1-A1 + (B1<A1)

or the more obscure, but equivalent

C1: =MOD(B1-A1,1)




In article ,
Dennis wrote:

I am setting up a spreadsheet to figure on start time from the end time to
start time. I need to subtract time from the previous cell to the next cell.