Thread: Show a time 50 min before entered time
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cristo cristo is offline
external usenet poster
  
Posts: 2
Default Show a time 50 min before entered time
I want to enter a time in cell d2 and I want cell d2 to show 50 minutes
earlier. What formula can I use.
At present when I format the cells as Hrs & mins when I enter 0700 the time
returns as 00:00

Regards jcs
Reply With QuoteReply With Quote