Urgent help please

By kewljash ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

try the function =NOW()

by Absolutely In reply to Urgent help please

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

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

Collapse -

re: excel formula

by ThumbsUp2 In reply to Urgent help please

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.

Related Discussions

Related Forums