| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you convert decimal in to numbers
You're welcome.
Pete RICK wrote: GREAT, MANY MANY THANKS "Pete_UK" wrote: No need to SHOUT !! Excel stores time as fractions of a 24-hour day, so what might look like 12:00 is actually stored internally by Excel as 0.5. Thus you will need to multiply by 24 to convert the time differences into decimal hours. Assuming your data as shown in the example occupies columns A to E, you can try this formula in E2: =(B2 - A2 + D2 - C2) * 24 and format the cell as number with 2 decimal places. You should be aware that 8.25, for example, will represent 8 hours and 15 minutes. You can copy the formula down to give you a total for each line of data that you have. Hope this helps. Pete RICK wrote: I HAVE CREATED MY OWN SIMPLE TIME SHEET EVERY WEEK MONDAY TO FRIDAY SUCH AS THIS: BUT WHEN I ADD THE TOTAL HOURS WORKED I AM NOT ABLE TO GET THE ANSWER, PLEASE HELP WHAT SHOULD I DO??? IN OUT IN OUT TOTAL HRS 6:36 12:00 12:30 17:36 10:30 IN OUT IN OUT 6:36 12:00 12:30 17:36 10:30 IN OUT IN OUT 6:36 12:00 12:30 17:36 10:30 IN OUT IN OUT 6:36 12:00 12:30 17:36 10:30 IN OUT IN OUT 6:36 12:00 12:30 17:36 10:30 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert stored numbers into a set naming convention | Excel Worksheet Functions | |||
| convert numbers stored as numbers to text | Excel Worksheet Functions | |||
| convert letters to numbers | Charts and Charting in Excel | |||
| Convert numbers stored as text to numbers Excel 2000 | Excel Discussion (Misc queries) | |||
| How to convert Numbers to text | Excel Worksheet Functions | |||
Threaded Mode
