entering time in and time out

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a simple spreadsheet that will calculate hours worked. Having troubles getting the time format correct for formula and to also be simply entered. I want to be able to enter the "date" once in Col A, "Time in"= Col B, "Time out" Col C, hours worked=Col D. My problem is entering the time to meet the formula's needs. In other words I don't want to have to enter entire date and time for both col B and C. I want to use military time. Suggestions??
 
Paula,

Just put =C1-B1 in D1, and format as time.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

paula said:
I am trying to create a simple spreadsheet that will calculate hours
Click to expand...
worked. Having troubles getting the time format correct for formula and to
also be simply entered. I want to be able to enter the "date" once in Col
A, "Time in"= Col B, "Time out" Col C, hours worked=Col D. My problem is
entering the time to meet the formula's needs. In other words I don't want
to have to enter entire date and time for both col B and C. I want to use
military time. Suggestions??
 
Back
Top