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
|