Thread: Calculate end time
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default Calculate end time
One way:

=A2+A3/1440


XL stores times as fractional days, and there are 24*60, or 1440 minutes
in 1 day.

In article ,
njbpitt wrote:

I have StartTime in A2, Number of Minutes in A3. How do I calculate EndTime
in A4? Thanks
Reply With QuoteReply With Quote