Time values for courses

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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...
 
Back
Top