| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
You are welcome!
-- Gary''s Student "Brent E" wrote: Excellent. I tried both of these suggestions and they work fabulously. Thanks. I really appreciate the suggestions; have a fabulous day. "Gary''s Student" wrote: If time is in A1 then =HOUR(A1)+MINUTE(A1)/60 will work if formatted as General -- Gary''s Student "Brent E" wrote: Good morning, Is there a formula or easy way to automatically convert a custom h:mm format to a decimal format? Situation: I am working on putting together an Excel Template for my boss for our departmental time sheets. I currently have these basic categories setup (worded differently but will use descriptive terms in this example). Day AM TIME IN, AM TIME OUT, PM TIME IN, PM TIME OUT, Total (h:mm format), and then a Total column (Decimal format) Currently I have the AM, PM cells and Total h:mm cells formatted as "custom" and set to "h:mm". And the Total Decimal Column format is set to "Number" and to 2 decimal places. Reason for 2 total columns is to sum the h:mm values to get a total value, and payroll needs the values in a decimal format (e.g. 8.25 hours). Suggestions would be greatly appreciated. Cordially, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert decimal degree (lattitude/longitude) into Degree, | Excel Discussion (Misc queries) | |||
| Excel adds phantom decimal places: why? | Excel Discussion (Misc queries) | |||
| FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
| How do I override fixed decimal place settings in EXcel 2003? | Excel Worksheet Functions | |||
| decimal point override does not work | Excel Discussion (Misc queries) | |||
Hybrid Mode
