dates to hours
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
"Mike H" wrote:
Hi,
A1= Earlier date/time
A2= later date/Time
A3 formula =A2-A1
Format A3 as [hh]:mm
Mike
"Champ" wrote:
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
|