time calculations

1. ## time calculations

I need to add hours & minutes, i.e. 1020:00 + 1020:00 = 2040:00. (HHHH:MM)
Excel calculates it using a 24 hour clock and I don't get the results I'm
looking for.
Do I need a formula to convert the time?
Or, would there be a special cell format.
--
Stevie

My System Specs

2. ## Re: time calculations

Why not convert from hours and minutes to hours, and fractions of hours, and
then back again.

So 10:45 + 10:30---> 10.75+10.5=21.25 ---> 21:15.

Dale

"Stevie" <StevieO@xxxxxx> wrote in message
news:BF868F1C-1963-47EA-8E48-8EA7EA55DF4E@xxxxxx

>I need to add hours & minutes, i.e. 1020:00 + 1020:00 = 2040:00. (HHHH:MM)
> Excel calculates it using a 24 hour clock and I don't get the results I'm
> looking for.
> Do I need a formula to convert the time?
> Or, would there be a special cell format.
> --
> Stevie

My System Specs

3. ## Re: time calculations

"Stevie" <StevieO@xxxxxx> wrote in message
news:BF868F1C-1963-47EA-8E48-8EA7EA55DF4E@xxxxxx

>I need to add hours & minutes, i.e. 1020:00 + 1020:00 = 2040:00. (HHHH:MM)
> Excel calculates it using a 24 hour clock and I don't get the results I'm
> looking for.
> Do I need a formula to convert the time?
> Or, would there be a special cell format.
> --
> Stevie

Are you trying to do this in Excel? If so, you should ask in an Office or
Excel newsgroup.

This is a programming group, so, as such, I would use a TimeSpan object as
follows:

static void Main(string[] args)
{
TimeSpan ts1 = new TimeSpan(10, 45, 0);
TimeSpan ts2 = new TimeSpan(10, 30, 0);
int H = (int) Math.Floor(ts3.TotalHours);
double M = ts3.TotalMinutes - (60 * H);
Console.WriteLine(string.Format("{0}:{1}", H, M));