Question Locked

Urgent help please

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have been working on a excel sheet, is there any way that we can add a formulae to set time. i mean to say there is a coloumn where it has a list for every minutes right from 0:00:00 to 23:59:59 it many cells in a day, i need to add the hour number for every cell in the adjoining coloumn, is there anyway that we can add formulae and then by using that it automatically gets reflected with the hours. please help me out of this.

3 replies

by absolutely

in the next cell, =NOW() +1, etc.

I'm not sure I understood your question. I hope that helps.

by thumbsup2

If you have the times typed into cells in column A, in column B (or anywhere you want), type =hour(A1) ... now, formatting with a leading zero is a different matter. You have to build a custom format to do that.

This discussion is closed to new replies.