Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
unique
 
Posts: n/a
Default how to calulate time

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

  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding time damezumari Excel Discussion (Misc queries) 2 June 20th 05 08:35 PM
time differences in a column 68magnolia71 Excel Worksheet Functions 3 May 9th 05 09:46 PM
Time Sheet Calculation Help Needed! sax30 Excel Worksheet Functions 2 April 26th 05 08:08 PM
Time Sheets Lady Layla Excel Discussion (Misc queries) 1 March 23rd 05 03:22 PM
unmet challenge boris Excel Worksheet Functions 2 March 16th 05 02:13 PM


All times are GMT +1. The time now is 05:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"