S_T_E_V_E_N
New Member
- Joined
- Jun 9, 2020
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
Hi, I would like to ask a question on the time format. I get a document with times already on it example 01:35:15 depicting HH:MM:SS. When pulling the cell through to another document with a formulae such as the "+" function or the "sumif" function it pulls through 00:00:00 and not the 01:35:15. Why is this happening and how do I change it? I've tried clearing the entire cell and that does not work. When I review the cell it shows me 1900/01/01 00:00:00 and not the cell reference.