Time Format not picking up correctly

S_T_E_V_E_N

New Member
Joined
Jun 9, 2020
Messages
6
Office Version
  1. 365
Platform
  1. 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.
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
11,980
Office Version
  1. 365
Platform
  1. Windows
Is it 1900/01/01 or 1900/01/00 ?

The first example suggests that your times add up to exactly 24 hours, in which case, if you expect to see 24:00:00 then you need to change the cell format to [hh]:mm:ss
 

S_T_E_V_E_N

New Member
Joined
Jun 9, 2020
Messages
6
Office Version
  1. 365
Platform
  1. Windows
I cannot check right now as its not my document but im just trying to pull through a cell with the "+" function and it works for some but not all
 

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
11,980
Office Version
  1. 365
Platform
  1. Windows
Reading your post again, it looks like I misread what is happening.

I would suggest repeating the same steps on different workbooks and different computers, if possible send the problem document to a different computer for testing.

What you describe is definitely not normal, so the first thing to establish is the origin of the problem.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,307
Messages
5,600,869
Members
414,411
Latest member
Snowmanaus

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top