View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 618
Default 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