Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
=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. . |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help wtih date and time in the same cell | Excel Worksheet Functions | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Worksheet Functions |