Time Calculation
 

I have a spreadsheet which is properly doing a time
calculation...Y5-A2...from Y5 cell 12:54 and cell A2 which is the current
time. Is there any way I can take another 30 minutes off of this
calculation???

Y2-A2-????

Time Calculation
 

=Y2-A2-30/(24*40)

HTH
Kostis Vezerides


wnfisba wrote:
I have a spreadsheet which is properly doing a time
calculation...Y5-A2...from Y5 cell 12:54 and cell A2 which is the current
time. Is there any way I can take another 30 minutes off of this
calculation???

Y2-A2-????

Time Calculation
 

=Y5-A2-TIME(0,30,0)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"wnfisba" wrote in message
...
I have a spreadsheet which is properly doing a time
calculation...Y5-A2...from Y5 cell 12:54 and cell A2 which is the current
time. Is there any way I can take another 30 minutes off of this
calculation???

Y2-A2-????

Time Calculation
 

"vezerid" wrote in message
oups.com...

wnfisba wrote:
I have a spreadsheet which is properly doing a time
calculation...Y5-A2...from Y5 cell 12:54 and cell A2 which is the current
time. Is there any way I can take another 30 minutes off of this
calculation???

Y2-A2-????

=Y2-A2-30/(24*40)

HTH
Kostis Vezerides

But only if you're in a part of the world where there are 40 minutes in an
hour. :-)
--
David Biddulph

Time Calculation
 

Bob. How about ... Date and time subtracted from each other to give
aDay,Hour and Minute return?

Regards

Dan

"Bob Phillips" wrote:

=Y5-A2-TIME(0,30,0)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"wnfisba" wrote in message
...
I have a spreadsheet which is properly doing a time
calculation...Y5-A2...from Y5 cell 12:54 and cell A2 which is the current
time. Is there any way I can take another 30 minutes off of this
calculation???

Y2-A2-????

Time Calculation
 

As long as the difference is less than 32 days you could just subtract one
from the other, and use a format of "d h:mm:ss" (without the quotes)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Michell Major" wrote in message
...
Bob. How about ... Date and time subtracted from each other to give
aDay,Hour and Minute return?

Regards

Dan

"Bob Phillips" wrote:

=Y5-A2-TIME(0,30,0)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"wnfisba" wrote in message
...
I have a spreadsheet which is properly doing a time
calculation...Y5-A2...from Y5 cell 12:54 and cell A2 which is the
current
time. Is there any way I can take another 30 minutes off of this
calculation???

Y2-A2-????