LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
LM813
 
Posts: n/a
Default Time Sheets (Yes, I've already done a search on previous posts)


I am trying to set up a kind of unique time sheet - I want it to have 3
in/out times, and a total number of HOURS worked per day. This is what
I want it to look like:

B C
Time In: 8:00 AM
Time Out: 12:00 PM
Time In: 12:30 PM
Time Out: 4:00 PM
Time In: 5:30 PM
Time Out: 7:00 PM

Total hours: _____

Could someone help me with a formula, please?


--
LM813
------------------------------------------------------------------------
LM813's Profile: http://www.excelforum.com/member.php...o&userid=30385
View this thread: http://www.excelforum.com/showthread...hreadid=500492

 
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
create formula to add 15 minutes to previous time value Bruce Excel Worksheet Functions 2 April 4th 23 10:39 AM
time sheets karen Excel Discussion (Misc queries) 1 July 23rd 05 01:42 PM
CHANGE SET-UP ON MULTIPLE SHEETS AT 1 TIME DEMONET48 Excel Discussion (Misc queries) 2 January 14th 05 08:37 PM
set or reset the print range for several sheets at a time? Mestrella31 Excel Discussion (Misc queries) 2 January 10th 05 09:07 PM
how to open and see 2 excel work sheets at a time cwm Excel Discussion (Misc queries) 3 December 26th 04 01:27 PM


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

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"