Thread: Calculating Time with a number value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Corey Corey is offline
external usenet poster
  
Posts: 363
Default Calculating Time with a number value
I want to add a cell(number value) to a cell that is formatted to a time.
A1= 15
A2= 7:30AM
A3= (7:30AM + 15{mins}) Result to be 7:45AM

How can i do this ??


Corey....


Reply With QuoteReply With Quote