Thread: How can I add a numeric value to a TIME cell?
View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default
=A1+B1/24

where A1 holds London time, and B1 is the hours difference

--

HTH

RP

"david" wrote in message
...
need to create a spreadsheet with greenwich mean and Tokyo time


Reply With QuoteReply With Quote