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

--
HTH

Bob Phillips

"henryyhw" wrote in message
...

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