Thanks:  0
Likes:  0

# Thread: formula for time to 10th of an hour

1. Im looking for how excell turns minutes into tenth of an hour. As in; if cell A1=5:30pm then cell A1 would read 5.5p or pm.
Im putting in cell..A1=5.5p,(pm)...in cell B1=2.0a,(am). Then in cell C1= the total elapsed time. That will make it past midnight.
.....B1=2.0a..(-)..A1=5.5p....C1=8.5hours.

[ This Message was edited by: cblincoln43 on 2002-04-04 09:21 ]

[ This Message was edited by: cblincoln43 on 2002-04-04 09:22 ]

2. As in; if cell A1=5:30pm then cell A1 would read 5.5p or pm.
Can't be done with formatting.

3. On 2002-04-04 09:20, cblincoln43 wrote:
Im looking for how excell turns minutes into tenth of an hour. As in; if cell A1=5:30pm then cell A1 would read 5.5p or pm.
Im putting in cell..A1=5.5p,(pm)...in cell B1=2.0a,(am). Then in cell C1= the total elapsed time. That will make it past midnight.
.....B1=2.0a..(-)..A1=5.5p....C1=8.5hours.

[ This Message was edited by: cblincoln43 on 2002-04-04 09:21 ]

[ This Message was edited by: cblincoln43 on 2002-04-04 09:22 ]
Hi cblincoln43:
cell A2 ... 5:30 PM
cell B2 ... 2:00 AM

cell c2 ... =IF(B2-A2<0,B2-A2+1,B2-A2)*24
format cell C2 as CUSTOM 0.00 "hours"
result

8.50 hours

_________________
Yogi Anand

Edit: Deleted inactive website from hardcoded signature

[ This Message was edited by: Yogi Anand on 2003-01-19 14:08 ]

4. Does this mean i have to use the 12hour clock as an in 5:00pm,, not tenthsas in 5.0 pm or(p)

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•