How to Calculate Time

H

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
 
S

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
 
Top