ST Alpha - "STIS: Excel - how do I convert hours into decimal (like 2:30 is 2.5)? -- nm" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Login
Create Account

Search Dr. S. Talk
TT/ST Wiki
How Well Do You Know ...

RSS Feed

Hosting by DigitalOcean

Support ST on Ko-Fi

Down to Post

Backboards:

Posts: 153

STIS: Excel - how do I convert hours into decimal (like 2:30 is 2.5)? -- nm

Posted by Mop (205 lbs) (aka rburriel) Jun 20 '11, 12:14

(No message)

Responses:

=((A1)*1440)/60 -- nm - JaxSean Jun 20, 12:27 1
- ty! -- nm - Mop (205 lbs) Jun 20, 12:29
Format Cells > Number -- nm - znufrii Jun 20, 12:15

Post a message top

Replies are disabled on threads older than 7 days.