View Single Post
  #3   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

beautiful.
Thanks



"Peo Sjoblom" wrote in message
...
Try

=A2+A1/1440

format as time if necessary


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)


"Corey" wrote in message
...
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....