Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Fun with Time values | Excel Discussion (Misc queries) | |||
Macro to open workbook and copy and paste values in to orig workbo | Excel Worksheet Functions | |||
need help with - time values... | Excel Discussion (Misc queries) | |||
Time Values | Excel Discussion (Misc queries) | |||
How do you find the difference between two time values when one i. | Excel Discussion (Misc queries) |