| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
TIME KEEPING BY TENTHS
I need to make a formula for time keeping, such as 8:06 = 8:10
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
TIME KEEPING BY TENTHS
Multply your time by 24 and format as general
Mike "Pam" wrote: I need to make a formula for time keeping, such as 8:06 = 8:10 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
TIME KEEPING BY TENTHS
On Thu, 5 Jun 2008 07:20:11 -0700, Pam
wrote: I need to make a formula for time keeping, such as 8:06 = 8:10 Try this: =TIME(HOUR(A1),MROUND(MINUTE(A1),10),0) and format the cell as t:mm Hope this helps. / Lars-Åke |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculating time with tenths | Excel Discussion (Misc queries) | |||
| Average time for a race in minutes seconds & tenths | Excel Worksheet Functions | |||
| Help with Time Keeping Formula | Excel Worksheet Functions | |||
| Time Keeping | New Users to Excel | |||
| Convert Time...!convert tenths of a second | Excel Discussion (Misc queries) | |||
Linear Mode
