dates to hours

[Champ]

I have two times in my spreadsheet.
I have a job that has a start time that begins at 07:00 and ended the job
3-days later at 23:47.
The real lapsed time is days from start to finish, however I keep getting a
(-) negative, ###### answer.
Does anyone know how to eqaute this into hours, ie: 88:47? (positive hours)

Thanks,
Champ

 

[Mike H]

Hi,

A1= Earlier date/time
A2= later date/Time
A3 formula =A2-A1
Format A3 as [hh]:mm

Mike

 

[Champ]

Mike thanks, that does work.
I was trying to keep the format of times only, but doing that never will
define the date, just the times.

Is there a way for the times to look at another set of cells and then
calculate this?

If not, what you gave is just fine.

ex:
IN OUT

6/18/08 22:30 6/20/08 22:30
Cell A1 B1 C1 D1

Just a thought...

Thanks again,
Champ

Hi,

A1= Earlier date/time
A2= later date/Time
A3 formula =A2-A1
Format A3 as [hh]:mm

Mike

I have two times in my spreadsheet.
I have a job that has a start time that begins at 07:00 and ended the job
3-days later at 23:47.
The real lapsed time is days from start to finish, however I keep getting a
(-) negative, ###### answer.
Does anyone know how to eqaute this into hours, ie: 88:47? (positive hours)

Thanks,
Champ