View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marty Marty is offline
external usenet poster
 
Posts: 116
Default 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