| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time in excel
When I type time over 24 hours, it will only show the balance of time under
24 hours. I want to add time and have tried using the Microsoft training tutorial, but it still doesn't work |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Time in excel
Try to format cell like "[h]:mm" or "[h]:mm:ss"
Regards, Stefi €˛tangle€¯ ezt Ć*rta: When I type time over 24 hours, it will only show the balance of time under 24 hours. I want to add time and have tried using the Microsoft training tutorial, but it still doesn't work |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Time in excel
try to format the cell as [h]:mm:ss
hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "tangle" escreveu: When I type time over 24 hours, it will only show the balance of time under 24 hours. I want to add time and have tried using the Microsoft training tutorial, but it still doesn't work |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Time in excel
Thanks, you're both brilliant
"Marcelo" wrote: try to format the cell as [h]:mm:ss hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "tangle" escreveu: When I type time over 24 hours, it will only show the balance of time under 24 hours. I want to add time and have tried using the Microsoft training tutorial, but it still doesn't work |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time difference calculations, daylight savings time, Excel | Excel Discussion (Misc queries) | |||
| In Excel, I want to convert Eastern time to pacific time | Excel Discussion (Misc queries) | |||
| Negative time should be allowed in Excel, eg time difference | Excel Discussion (Misc queries) | |||
| How do I time Hours & mins in excel - Time sheet | Excel Discussion (Misc queries) | |||
| Accumulate weekly time to total time in Excel. | Excel Discussion (Misc queries) | |||
Linear Mode
