View Single Post
  #1   Report Post  
henryyhw henryyhw is offline
Junior Member
 
Posts: 2
Default How to Calculate Time

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