| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting decimal calculation to h:mm format
I am working on a time sheet for work that is using the excel program. The
sheet has clock in and clock out times in several different cells. I am trying to get the cell at the end of the row to display the amount of time work in hours and minutes, not decimal. For instance it says 0.00 hours instead 0:00. I am using a template that currently uses a formula as follows to calculate the time: =IF((OR(D11='''',C11='''')),0,IF((D11<C11),((D11-C11)*24)+24,(D11-C11)*24)) Can someone please help me!!!! I am getting very flustered trying to figure this out. Thank You |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format percentage as a decimal | Excel Discussion (Misc queries) | |||
| Converting number or text to a Date Format | New Users to Excel | |||
| h:mm to decimal value | Excel Discussion (Misc queries) | |||
| Converting a large vertical mailing list into a horizontal format | New Users to Excel | |||
| Keep number format after converting time to text | Excel Discussion (Misc queries) | |||
Threaded Mode
