Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kyle Sweeney
 
Posts: n/a
Default Adding Time

Can anyone help me with this.

I want to add 2 cells time (military time) and convert it to hours. This is
for a payroll system. Saying we are using the following setup:

A1= 0600
A2= 1800
A3= ????

Where A3 is the total hours worked

Thanks


 
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
Help with Adding Time Hrs and Mins Mike Busch Excel Discussion (Misc queries) 1 November 23rd 05 04:24 PM
Adding time trucker New Users to Excel 1 November 22nd 05 10:18 PM
Entering Times Denise Excel Discussion (Misc queries) 9 November 15th 05 04:57 PM
adding in time formats rvnwdr Excel Discussion (Misc queries) 1 May 31st 05 11:38 PM
Adding time to multiple cells using TIMECODE timroutledge Excel Discussion (Misc queries) 1 May 25th 05 06:24 PM


All times are GMT +1. The time now is 01:21 AM.

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

About Us

"It's about Microsoft Excel"