ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   how to calulate time (https://www.excelbanter.com/new-users-excel/33836-how-calulate-time.html)

unique

how to calulate time
 
this is my first time using excel in payroll, please tell me how to add time.


Peo Sjoblom

No difference to any other numbers, just add the time, you can use a format
of [hh]:mm to display + 24 hours

=SUM(B2:B6)

where B2:B6 holds the hours

--
Regards,

Peo Sjoblom

(No private emails please)


"unique" wrote in message
...
this is my first time using excel in payroll, please tell me how to add
time.




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

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