ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Time in excel (https://www.excelbanter.com/excel-worksheet-functions/169382-time-excel.html)

tangle

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

Stefi

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


Marcelo

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


tangle

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



All times are GMT +1. The time now is 10:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com