ExcelBanter - Time Sheets

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Time Sheets (https://www.excelbanter.com/excel-discussion-misc-queries/131842-time-sheets.html)

Malone

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?

Bob Phillips[_2_]

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?

Malone

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?

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