| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
time formatting
How do I convert 8.03 to 08:03 as time and how to calculate the table below
e.g. Need to work 8 hrs per day Time in Time out Difference Overtime Due time 8.03 16.00 ?? ?? ?? 8.00 15.45 ?? ?? ?? When an employee is absent 0.00 0.00 ?? ?? ?? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
time formatting
With 8.03 in A1 use:
=TIME(INT(A1),100*(A1-INT(A1)),0) -- Gary''s Student - gsnu200908 "harry" wrote: How do I convert 8.03 to 08:03 as time and how to calculate the table below e.g. Need to work 8 hrs per day Time in Time out Difference Overtime Due time 8.03 16.00 ?? ?? ?? 8.00 15.45 ?? ?? ?? When an employee is absent 0.00 0.00 ?? ?? ?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting time | Excel Discussion (Misc queries) | |||
| Formatting Time | Excel Worksheet Functions | |||
| Time formatting | Excel Discussion (Misc queries) | |||
| time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions | |||
| time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions | |||
Linear Mode
