| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to i add hrs that will have total more than 24hrs
version - excel 2003
i wanted to add number of hrs say 3:00, 5:20, 7:00,5:00, 5:50. Now the answer i should get is 26:10 but what i get is 2:10 that is above 24 hrs. could you please help me with this and above format is in hrs:mm Prasad |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to i add hrs that will have total more than 24hrs
Hi,
Format [hh]:mm Mike "laxmiprasad" wrote: version - excel 2003 i wanted to add number of hrs say 3:00, 5:20, 7:00,5:00, 5:50. Now the answer i should get is 26:10 but what i get is 2:10 that is above 24 hrs. could you please help me with this and above format is in hrs:mm Prasad |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to i add hrs that will have total more than 24hrs
hi prasad,
try this. =TEXT(SUM(A8:A12),"[hh]:mm") EricBB "laxmiprasad" wrote: version - excel 2003 i wanted to add number of hrs say 3:00, 5:20, 7:00,5:00, 5:50. Now the answer i should get is 26:10 but what i get is 2:10 that is above 24 hrs. could you please help me with this and above format is in hrs:mm Prasad |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I add time formatted cells together beyond 24hrs? | Excel Discussion (Misc queries) | |||
| deliver rosta 5 staff x 35hrs cover 24hrs p.a. | Excel Discussion (Misc queries) | |||
| help with assignment within next 24hrs | Excel Discussion (Misc queries) | |||
| how to add time above 24hrs... | New Users to Excel | |||
| Time Calc - 24hrs vs 0hrs | Excel Discussion (Misc queries) | |||
Linear Mode
