| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format & calculate time sheet template
I'm building a time sheet template to calculate hours worked each day and pay
period. My problem is setting up cell formatting to recognize a 3pm to 1:30AM shift, that will work in the calculations. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format & calculate time sheet template
Try this:
=MOD(B1-A1,1) With start in A1, and end in B1. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "ronnyj105" wrote in message ... I'm building a time sheet template to calculate hours worked each day and pay period. My problem is setting up cell formatting to recognize a 3pm to 1:30AM shift, that will work in the calculations. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format & calculate time sheet template
RD,
You're the Greatest! Tks, Ron "RagDyer" wrote: Try this: =MOD(B1-A1,1) With start in A1, and end in B1. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "ronnyj105" wrote in message ... I'm building a time sheet template to calculate hours worked each day and pay period. My problem is setting up cell formatting to recognize a 3pm to 1:30AM shift, that will work in the calculations. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format & calculate time sheet template
Appreciate the feed-back.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "ronnyj105" wrote in message ... RD, You're the Greatest! Tks, Ron "RagDyer" wrote: Try this: =MOD(B1-A1,1) With start in A1, and end in B1. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "ronnyj105" wrote in message ... I'm building a time sheet template to calculate hours worked each day and pay period. My problem is setting up cell formatting to recognize a 3pm to 1:30AM shift, that will work in the calculations. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I format the sheet so that I may click on 1 cell at a time | Excel Worksheet Functions | |||
| time sheet template available | Excel Discussion (Misc queries) | |||
| time sheet | Excel Discussion (Misc queries) | |||
| Time Sheet Calculation Help Needed! | Excel Worksheet Functions | |||
| formula to calculate a time sheet | Excel Worksheet Functions | |||
Linear Mode
