HELP WITH EXCEL ASAP

http://www.tutorialspoint.com/excel/excel_setting_cell_type.htm

>>8242717
I've done by this type of cell formating, but yet it still keeps on fucking me off

>>8242710
>microshit products

>>8242710

>(look at the photo i've attached)

OP, the phrase you're looking for is:

>pic realted

>>8242710
Looks like numerical errors.
How long is that column?

>>8242710
Could be because of floating point errors building up

>>8242710
>Taking a photo of the screen
This will never not make me think someone is a fucking retard

>>8242710
It seems that there are multiple days in each month

This is still a rather contentious topic among experts though

probably floating point error, especially if that's the end of a very long column

>>8242871
>This will never not make me think someone is a fucking retard

Eh, maybe it's a work computer so he doesn't want to go to 4chan on it but he can use his phone?

Also I tentatively agree w/ the "Floating Point inaccuracy" consensus. How long is that column?

>>8242867
This

Just manually enter the date at the point it fucks up and continue dragging the new date down.

>>8242710
>>8242862
this, can you start a new column?
also, try posting this on /g/

>>8242710
Heres what you do:

A1= starting time
B1= mround(A1 + time(1,0,0),"1:00")