I have four cells in a spreadsheet

start date
start time
end date
end time

I need to calculate in hours the difference between the start date and time
and the end date and time. This is probably quite easy, but I can't find the
way to do it. Unfortunately the cells have to remain seperate

Subtract as normal (start date + start time - end date - end time) and
multiply the result by 24. You'll probably have to format the resulting
number.

"Samwar" wrote:

I have four cells in a spreadsheet

start date
start time
end date
end time

I need to calculate in hours the difference between the start date and time
and the end date and time. This is probably quite easy, but I can't find the
way to do it. Unfortunately the cells have to remain seperate

=(startdate+starttime)-(enddate+endtime) and format the result something like
hhh.
--
Gary''s Student


"Samwar" wrote:

I have four cells in a spreadsheet

start date
start time
end date
end time

I need to calculate in hours the difference between the start date and time
and the end date and time. This is probably quite easy, but I can't find the
way to do it. Unfortunately the cells have to remain seperate

Make the format [h] instead

--
Kind regards,

Niek Otten

"Gary''s Student" wrote in message
...
=(startdate+starttime)-(enddate+endtime) and format the result something
like
hhh.
--
Gary''s Student


"Samwar" wrote:

I have four cells in a spreadsheet

start date
start time
end date
end time

I need to calculate in hours the difference between the start date and
time
and the end date and time. This is probably quite easy, but I can't find
the
way to do it. Unfortunately the cells have to remain seperate