formula date and time calculation

[changetires]

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

E

 

[daddylonglegs]

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

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

 

[daddylonglegs]

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

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

 

[Guest]

hi

just format your cell

regards from Brazil
Marcelo

"changetires" escreveu:

 

[changetires]

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

thk

 

[daddylonglegs]

As Marcelo says, this sounds like a formatting issue, can you jus
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 the
if you only want to add AB6 if positive try

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

 

[changetires]

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

tk

 

[changetires]

Cells D6,E6 have a date and time in them. Cell F6 will calculate th
difference of E6-D6.
Cell Z6 has a manual value put into it (like 15 for 15 hours or 10 fo
10 hours)
Cell Y6 will calculate the difference between the end date/time (Cel
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 thes
need to be just time only.

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

thk

 

[changetires]

anyone out here?