Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Can anyone help with the following problem in Excel 97
I would like to enter time as follows and total correctly in hours and minutes 10:35 10:57 10:20 Total 31:52 However what I have to do is enter_10_shift:_35_etc and this gives me the following 10:35: 10:57: 10:20: Total 31:52: I would rather not have the second set of colons Any suggestions ? Thank You |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding columns (one with a formula) | New Users to Excel | |||
Adding hours and minutes.. | Excel Discussion (Misc queries) | |||
Entering Data in multiple cells on one sheet & having it auto upda | Excel Worksheet Functions |