formula date and time calculation
 

My formula is calculating the difference in the number of days so my
result cell displays in hh:mm, but excel is using the long decimal
number in its calculation instead of the correct hours and/or minutes.
Why?

Ed


--
changetires
------------------------------------------------------------------------
changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=555974

formula date and time calculation
 

Excel stores time as a number, 1 day is 1, one hour = 1/24 so 6 hours is
the equivalent of 0.25, only the formatting makes it a time.

Does this help? If not please elaborate further, what formula are you
using, what result do you expect, what do you get?


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=555974

formula date and time calculation
 

Excel stores time as a number, 1 day is 1, one hour = 1/24 so 6 hours is
the equivalent of 0.25, only the formatting makes it a time.

Does this help? If not please elaborate further, what formula are you
using, what result do you expect, what do you get?


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=555974

formula date and time calculation
 

hi

just format your cell

regards from Brazil
Marcelo

"changetires" escreveu:


My formula is calculating the difference in the number of days so my
result cell displays in hh:mm, but excel is using the long decimal
number in its calculation instead of the correct hours and/or minutes.
Why?

Ed


--
changetires
------------------------------------------------------------------------
changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=555974

formula date and time calculation
 

Yeah, its using that decimal number in the calculation, I dont want it
to do this. The sheet I am using is using hh:mm as its dimensions, so
I am trying to keep all the cells displays in the same dimension but
the calc. is calculating in those decimals. Here is the formula for
cell I6...=1-F6/F6+AA6+AB6....but I only want this formula to use AB6
if the value in AB6 is greater than 0.....if you can help with that it
will also be appreciated.

thks


--
changetires
------------------------------------------------------------------------
changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=555974

formula date and time calculation
 

As Marcelo says, this sounds like a formatting issue, can you just
re-format to time? The calculation shouldn't be affected.

Not sure about your formula, do you mean (1-F6)/F6+AA6+AB6? If so then
if you only want to add AB6 if positive try

=(1-F6)/F6+AA6+MAX(0,AB6)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=555974

formula date and time calculation
 

Things are starting to work but I want to do the 1 minus after all the
addition and division are done. Its like taking the inverse of the
operation

tks


--
changetires
------------------------------------------------------------------------
changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=555974

formula date and time calculation
 

Cells D6,E6 have a date and time in them. Cell F6 will calculate the
difference of E6-D6.
Cell Z6 has a manual value put into it (like 15 for 15 hours or 10 for
10 hours)
Cell Y6 will calculate the difference between the end date/time (Cell
I6) and start date/time(cell E6)
Cell AA6 will calculate the difference between Z6-Y6

all these need to be displayed date/time except for Z6, AA6, F6 these
need to be just time only.

or if its easier just lemme email the sheet to ya and have a crack at
it

thks


--
changetires
------------------------------------------------------------------------
changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=555974

formula date and time calculation
 

anyone out here?


--
changetires
------------------------------------------------------------------------
changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=555974