Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert numeric to time
I am having a problem converting a numeric format to a time format.
3.5 to 3hour 30 minutes I need to be able to add up all hours for a time keeping function. Thanks, Corby |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert numeric to time
Divide by 24.
-- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Corby" wrote in message ... I am having a problem converting a numeric format to a time format. 3.5 to 3hour 30 minutes I need to be able to add up all hours for a time keeping function. Thanks, Corby |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert numeric to time
Chip Pearson has lots of date & time math info at his site:
http://www.cpearson.com/excel/datetime.htm#AddingTimes "Corby" wrote: I am having a problem converting a numeric format to a time format. 3.5 to 3hour 30 minutes I need to be able to add up all hours for a time keeping function. Thanks, Corby |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I convert a time to text format. | Excel Discussion (Misc queries) | |||
How do I convert text to time | Excel Worksheet Functions | |||
Numeric in Text to convert back to the form of Numeric for VLookup Purposes | Excel Discussion (Misc queries) | |||
How do I convert text answers to numeric | Excel Discussion (Misc queries) | |||
Convert Numeric into Text | Excel Worksheet Functions |