Happy to help. Thank you for the feedback.

tj

"Patrick" wrote:

Hey! Just like Bob said! Thank you both so much! The brackets made all the
difference. I've been working on this for days. So glad to have found you.
Thanks again Bob and "tjtjjtjt!"

"tjtjjtjt" wrote:

Putting the braces around the hours will make the time go passed 23:59. So,
change your format to:
[hh]:mm

tj

"Patrick" wrote:

Bob, the format is fine. It's just that when you get to 24:00 it switches
back to 0:00. I need it to keep adding all the way up to 70:00.

Patrick

"Bob Phillips" wrote:

Just format the total cell as [hh]:mm

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Patrick" wrote in message
...
I want to add hours and minutes in Excel but want the result to be
displayed
as hours and minutes. not in decimal form. In other words, if I have
Excel
add 17:30 +17:30+17:30+17:30 I want the total to come out to 70:00,
representing 70 hours and 0 minutes. I am increasing time in 15 minute
increments. I run into the expected problem when I get beyond 23:45 (23
hours
and 59) minutes. Then Excel, seeing this as time (mindnight) starts all
over
again and gives me 0:00. I do understand that Excel sees these type of
entries (17:30) as time and that is why it switches to 0:00 when it hits
24:00. I am just trying to find a way to tell it NOT to do that and to
just
keep increasing in the 15 minute increments I need to use, changing the
total
hours by 1 whenever the minutes reach :60.

Many thanks in advance for any suggestions!