? about time/date functions in sheet

[brianh]

Hello all-

Can anyone provide practical/applicable examples of how to use the time/date functions in sheet? Specifically, I need to calculate how long it takes to complete a task:

A2: Time started
A3: Time completed
A4: Elapsed Time

The examples provided in the Mako's internal help have not provided the answers I need (they probably have but I am unable to decipher).

Any help would be greatly appreciated.

[Beakynet]

First, the cells in Sheet should be formatted in Time (i.e. I use Format->Number->13:30:55

this will allow you to enter time started and ended.

The formula to calculate the elaspsed time is then very straight forward:

=A3-A2

there is no need to use any specific time functions for this type of calculation.

Hope this is what you are looking for.:)

[brianh]

Hello-

You are right. Thanks for the insight as it will help a great deal. I figured it was something so simple that I would overlook it...

Thanks for the help.