Time values for courses

M

marty

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
 
T

T. Valko

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
 
M

marty

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


T. Valko said:
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 said:
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
Click to expand...
Click to expand...
 
Top