Excel Formulas for date & time

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

Guest

Help! I'm putting together a spreadsheet that has a range of date and time values, check in and check out. I now need to use these numbers to find the number of days and hours a person was admitted, and convert this into a decimal number. Does anyone know a formula that will work? Thanks

grinnyp
 
=(start_date_time-end_date_time)*24

will give you decimal hours if you format as general or numbers

--

Regards,

Peo Sjoblom

grinnyp said:
Help! I'm putting together a spreadsheet that has a range of date and
Click to expand...
time values, check in and check out. I now need to use these numbers to
find the number of days and hours a person was admitted, and convert this
into a decimal number. Does anyone know a formula that will work? Thanks.
 
Just subtract the out date/time from the in date/time and format that
result cell as General.

--

HTH

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

grinnyp said:
Help! I'm putting together a spreadsheet that has a range of date and
Click to expand...
time values, check in and check out. I now need to use these numbers to
find the number of days and hours a person was admitted, and convert this
into a decimal number. Does anyone know a formula that will work? Thanks.
 
----- Peo Sjoblom wrote: ----

=(start_date_time-end_date_time)*2

will give you decimal hours if you format as general or number

Okay, pretend I'm a complete idiot. :-) If I put that formula in the column where I want the decimal hours to go, how do I get it to pick up the date and time from the check in column and the date & time from the check out column to perform this operation for each separate row

Thanks

Carol Ann
 
Back
Top