Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting a cell to calculate time.
I have a time sheet that has a group of cells that calculate vacation or sick
time earned and used. How do I format a cell so that 0:45 shown in the cell means 45 minutes and not 12:45 am. -- Lee Davenport |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transfer Cell Formatting for linked cells | Excel Discussion (Misc queries) | |||
How do I write the formula to calculate someones time worked | Excel Worksheet Functions | |||
Excel automatically changes the formatting of the cell to "Time" | Excel Discussion (Misc queries) | |||
cell formatting problems | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions |