J. Gorman

Posts: n/a

how do I change time data to numerical result

I am trying to create a roster spread sheet to calculate amount of hours and
cost. I would like to know how to change my result from formula. i.e.
8h:30min to 8.5 hours?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conversion	SVC	Excel Worksheet Functions	9	February 28th 05 02:29 PM
change directory for refresh data	TxRaistlin	Excel Discussion (Misc queries)	0	February 7th 05 09:09 PM
Calculate change over time	Gwen	Excel Worksheet Functions	0	January 1st 05 05:52 PM
Convert data type of cells to Text,Number,Date and Time	Kevin	Excel Worksheet Functions	1	December 31st 04 12:57 PM
Is there a formula to spell out a number in excel?	Sha-nay-nay	Excel Worksheet Functions	2	December 18th 04 09:25 PM

All times are GMT +1. The time now is 06:59 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us