How to Calculate Time

[henryyhw]

Dear All,
I have date field in Column A (e.g. 02/06/2005) and a time field in
Column B (e.g. 05:15), how can I deduct 8 hours from this 2 fields
(e.g. the results show 01/06/2005 21:15)??

Thanks a lot


--
henryyhw

[swatsp0p]

Format cell C1 as Custom: dd/mm/yyyy hh:mm and enter this formula:

=(A1+B1)-0.333

returns 01/06/2005 21:15

note that 8 hours is 0.333 of one day

Does this work for you?

Bruce

[Bob Phillips]

=A1+B1-time(8,0,0) and format as date/time.

--
HTH

Bob Phillips

"henryyhw" <[email protected]> wrote in message
news:[email protected]...
>
> Dear All,
> I have date field in Column A (e.g. 02/06/2005) and a time field in
> Column B (e.g. 05:15), how can I deduct 8 hours from this 2 fields
> (e.g. the results show 01/06/2005 21:15)??
>
> Thanks a lot
>
>
> --
> henryyhw