time.xls

<div>
<div class="content wysiwyg-content">
Hi this is a frustrating question .<br />
<br />
I have a runners excel spread sheet it consists of<br />
<br />
a1: Pace &nbsp;(format 6:30) &nbsp;6 minutes 30 seconds<br />
a2: Miles (eg 5)<br />
a3: Start Time : formatted as time (1:30 PM)<br />
a4 : End Time : To be calculated (Format also time (1:30 PM)<br />
a5 : Duration : Format [h]:mm (calculated by a1*a2) &nbsp;32:30<br />
<br />
I cant seem to get a4 to come out right. &nbsp;<br />
<br />
If I use =a3+a5 it doesnt work, <br />
if i use a3+time(0,32,30) it displays fine, <br />
<br />
any help ?
</div>
</div>


Hi this is a frustrating question .

I have a runners excel spread sheet it consists of

a1: Pace  (format 6:30)  6 minutes 30 seconds
a2: Miles (eg 5)
a3: Start Time : formatted as time (1:30 PM)
a4 : End Time : To be calculated (Format also time (1:30 PM)
a5 : Duration : Format [h]:mm (calculated by a1*a2)  32:30

I cant seem to get a4 to come out right.  

If I use =a3+a5 it doesnt work, 
if i use a3+time(0,32,30) it displays fine, 

any help ?

Excel Time Question

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.