Good point

Without the IF

B1-A1+(A1B1)


"Govind" wrote in message
...
There could be a possibility that the end time is lower than Start time
where the time spills over to the next day.

To cover such cases, you can use

= IF(B1<A1,B1+1-A1,B1-A1)

Regards

Govind.

Paul Corrado wrote:
Just subtract the times. With Start time in A1 and End time in B1

=B1-A1




"joeh" wrote in message
...

I am trying to make a spread sheet that I can enter a starting time and

and

ending time to treack the amount of hours spent on projects. I format my
starting and ending times cells as times but I can not figure out the

formula

to use to take these times and calculate the amount of time between
them.

If

anyone knows how to do this please let me know. You can email me at
. Thanks for the help.