#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Time Sheets

Hi, I want to calculate empoyee time sheets in excel. I want ot enter a
start time and a finish time and get the total hours worked. If A is start
and B is finish it is a simple B - A but you run into a problem for people
who work across the midnight hour. How do I get around this?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Time Sheets

=MOD(B1-A1,1)

HTH

Bob


"Malone" wrote in message
...
Hi, I want to calculate empoyee time sheets in excel. I want ot enter a
start time and a finish time and get the total hours worked. If A is
start
and B is finish it is a simple B - A but you run into a problem for people
who work across the midnight hour. How do I get around this?



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Time Sheets

thanks

"Bob Phillips" wrote:

=MOD(B1-A1,1)

HTH

Bob


"Malone" wrote in message
...
Hi, I want to calculate empoyee time sheets in excel. I want ot enter a
start time and a finish time and get the total hours worked. If A is
start
and B is finish it is a simple B - A but you run into a problem for people
who work across the midnight hour. How do I get around this?




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
Time log adding time from separate sheets teastman New Users to Excel 1 December 31st 05 05:14 PM
time sheets karen Excel Discussion (Misc queries) 1 July 23rd 05 02:42 PM
Time Sheets Helen Black Excel Worksheet Functions 0 March 21st 05 10:32 AM
Time Sheets Helen Black Excel Worksheet Functions 0 March 18th 05 10:34 AM
Time Sheets Helen Black Excel Worksheet Functions 1 March 17th 05 05:14 PM


All times are GMT +1. The time now is 12:45 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"