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

=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

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


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=375947

It works, thanks a lot for your help.

I'm glad it worked for you. Thanks for the feedback, it is always
appreciated.

Cheers!

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=376222