Time values for courses
 

Hi All;

i have a curriculum spreadsheet with course names and time values for the
course.

For exaple: Intro to Widgets - 1:45 (1 hour 45 Min) The time value is
formatted as HH:MM and displays just fine.

i have a second course: Introduction to Gizmos - 2:00 (2 in length

When I try to sum the 1:45 and 2:00 courses, I get a sum that says 1:50 AM.
I really need a sum that gives 3:45 as the total time for the two courses.
Any simple, easy way to do this? (SInce my real curiculum list has about 150
courses)

TIA
--
Marty

Time values for courses
 

Try formatting the cell that holds your sum formula as [h]:mm

The brackets [ ] keep the hours from rolling over back to 0 at 24.

Biff

"marty" wrote in message
...
Hi All;

i have a curriculum spreadsheet with course names and time values for the
course.

For exaple: Intro to Widgets - 1:45 (1 hour 45 Min) The time value is
formatted as HH:MM and displays just fine.

i have a second course: Introduction to Gizmos - 2:00 (2 in length

When I try to sum the 1:45 and 2:00 courses, I get a sum that says 1:50
AM.
I really need a sum that gives 3:45 as the total time for the two courses.
Any simple, easy way to do this? (SInce my real curiculum list has about
150
courses)

TIA
--
Marty

Time values for courses
 

Thanks. I'll try that and let you know how it turns out.
--
Marty


"T. Valko" wrote:

Try formatting the cell that holds your sum formula as [h]:mm

The brackets [ ] keep the hours from rolling over back to 0 at 24.

Biff

"marty" wrote in message
...
Hi All;

i have a curriculum spreadsheet with course names and time values for the
course.

For exaple: Intro to Widgets - 1:45 (1 hour 45 Min) The time value is
formatted as HH:MM and displays just fine.

i have a second course: Introduction to Gizmos - 2:00 (2 in length

When I try to sum the 1:45 and 2:00 courses, I get a sum that says 1:50
AM.
I really need a sum that gives 3:45 as the total time for the two courses.
Any simple, easy way to do this? (SInce my real curiculum list has about
150
courses)

TIA
--
Marty