Hi
or even
=MOD(B1-A1,1)

--
Regards
Frank Kabel
Frankfurt, Germany

"Paul Corrado" schrieb im
Newsbeitrag ...
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.