View Single Post
  #6   Report Post  
kkrebs
 
Posts: n/a
Default

I'm sorry. My blond roots were showing again. I had the wrong formula.
Thank you for all your help.

"Frank Kabel" wrote:

Hi
so tell us please:
- what formula have you tried exactly
- what values are in the referenced cells
- what is your expected result

--
Regards
Frank Kabel
Frankfurt, Germany

kkrebs wrote:
Thanx, but when I try either of these my answer comes out to 1290:00.
What am I doing wrong?

"Frank Kabel" wrote:

Hi
try
=A2-A1
if these are your times. For the final result use a custom format
such as [mm]:ss

--
Regards
Frank Kabel
Frankfurt, Germany
"kkrebs" schrieb im Newsbeitrag
...
I am trying to do a spread sheet where I have a starting time of
10:00am and
an ending time of 11:30am and I want the sum to be total minutes
not hours and minutes. It comes out at 30:00 and I can't figure
out how to have it add
in the other hour. Can any one help?

Thank you!

Kim