Excel Formulas for date & time

[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

 

[Peo Sjoblom]

=(start_date_time-end_date_time)*24

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

--

Regards,

Peo Sjoblom

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.

 

[Bob Phillips]

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)

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.

 

[Guest]

----- 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