I would like to created a simple spread sheet in excel that I
can put clock in hrs &clock out hrs and get a total

If your "Time In" is in column A and your "Time Out" is in column B, both
starting in row 1 for this example, then put this in C1

=MOD(B1-A1,1)

and copy down for as many rows as you have data.

Rick