Posted to microsoft.public.excel.worksheet.functions
|
|
How calculate end time with beginning time plus formula minutes
How are the minutes calculated? As an integer like: 10 = 10 minutes?
A1 = 12:00 AM
B1 = 10
=A1+B1/1440
Or:
=A1+TIME(0,B1,0)
Format as Time or custom h:mm
--
Biff
Microsoft Excel MVP
"Calculate an ending time" <Calculate an ending
wrote in message
...
How do you have a beginning time then use the result of a formula that
calculates a certain # of minutes then adds the minutes to the beginning
time
and display the ending time?
|