| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
sum total hours and minutes
ok I have read all the questions and answers and I still can't get my program
to work: here is what I do: July Event StartTime End Time 8 Purchase cat food / diet pepsi / rug cleaner 1:30 PM 2:15 PM 00:45 15 Pay house gas and phone bills 10:00 AM 10:30 AM 00:30 the format I use for start time is: TIME 1:30PM the format I use for end time: TIME 2:15PM the last column formula is: =TEXT(D4-C4,"hh:mm") when I try to total that column for number of hours I keep getting 00:00 when I should get 1:15 for 1 hour 15 minutes. CAN ANYONE HELP out on this please? Thanks Carson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding hours and minutes | Excel Worksheet Functions | |||
| calculating timesheet, time-in/time-out = total hours & minutes, . | Excel Worksheet Functions | |||
| add hours & minutes to other hours & minutes to receive total hou. | Excel Worksheet Functions | |||
| convert hours and minutes to minutes | Excel Discussion (Misc queries) | |||
| add column of minutes, show total in hours & minutes | Excel Worksheet Functions | |||
Threaded Mode
