software

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.

quot;Samwarquot; wrote:

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

=(startdate starttime)-(enddate endtime) and format the result something like
hhh.
--
Gary''s Studentquot;Samwarquot; wrote:

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

Make the format [h] instead

--
Kind regards,

Niek Otten

quot;Gary''s Studentquot; gt; wrote in message
...
gt; =(startdate starttime)-(enddate endtime) and format the result something
gt; like
gt; hhh.
gt; --
gt; Gary''s Student
gt;
gt;
gt; quot;Samwarquot; wrote:
gt;
gt;gt; I have four cells in a spreadsheet
gt;gt;
gt;gt; start date
gt;gt; start time
gt;gt; end date
gt;gt; end time
gt;gt;
gt;gt; I need to calculate in hours the difference between the start date and
gt;gt; time
gt;gt; and the end date and time. This is probably quite easy, but I can't find
gt;gt; the
gt;gt; way to do it. Unfortunately the cells have to remain seperate