putting date and time together in 1 cell
Hi I need to convert New Zealand time to UK time, the time
is displayed in two parts A B date time dd/mm/yy hh:mm:ss How do i get cell A and cell B into one cell with the format dd/mm/yy hh:mm:ss and then I can just minus 13 hours. any ideas please. |
=SUM(A2,B2,-13/24)
and format the cell as dd/mm/yy hh:mm:ss. HTH Jason Atlanta, GA -----Original Message----- Hi I need to convert New Zealand time to UK time, the time is displayed in two parts A B date time dd/mm/yy hh:mm:ss How do i get cell A and cell B into one cell with the format dd/mm/yy hh:mm:ss and then I can just minus 13 hours. any ideas please. . |
try
=text(now(),"dd/mm/yy hh:mm:ss") -- Don Guillett SalesAid Software "Robbie" wrote in message ... Hi I need to convert New Zealand time to UK time, the time is displayed in two parts A B date time dd/mm/yy hh:mm:ss How do i get cell A and cell B into one cell with the format dd/mm/yy hh:mm:ss and then I can just minus 13 hours. any ideas please. |
All times are GMT +1. The time now is 01:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com