Autofill date and time...

M

mauddib13

I am trying to find a way to have excel populate the current date and
military time into a cell. Is this possible?
 
M

mauddib13

That Helps thanks... I tried that before and it did not work, but now it
is... Thanks... Also I am trying to figure a way to convert a number
into time format... Ex. is turning 40.92 into how many hours and
minutes and or seconds..
 
M

mauddib13

Sorry, just posting the reply to it as well.. I figured that one out
thanks.. But still have another set back what this whole thing is about
involves an online game. I am piecing this whole calculation sheet
together. Here are the req's...
I produce (x) number of points an hours
I have (y)% bonus
Then I have (z) as the number of points I must hit in order to achive
next level...

What I need is for the formula to take the equation of x&y which we
have already achived and have z/y which we also have achived. But the
tricky part is to have that number synced with current time and change
as the current time changes. So as the time goes foward, the other
value goes back.
Ex.
Current time 4/17/06 11:14 --- Syncs with the Now() command
Till Culture 37:52:00 ---- This needs to change as the current time
changes
Exact Culture 4/19/06 1:06 ---- will always stay the same untill next
level is in affect
 
Top