Time Calculation

W

wnfisba

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-????
 
B

Bob Phillips

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

--
HTH

Bob Phillips

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

Michell Major

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

Regards

Dan
 
B

Bob Phillips

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)
 
Top