| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
add time and convert it to currency
Hi
I got question for u Pls help me I am tired of this I have a1 = 8:00 (format cell = [h]:mm), a2 = 9:00 (format cell = [h]:mm) , a3 = 9:10 (format cell = [h]:mm) I have a6 = sum(a1:a3)*24 (format cell = number) - This formula suppose to add numbers from a1 to a3 The problem is instead of getting 26 hours 10 minutes i am keep getting 26 hours 17 minutes What can I do to figure out this problem? If u have sollution pls explain me that and if it is possible can u send me an e-mail with excel file so i can see how did u do that? My e-mail adress is P.s Again I am trying to convert from format time to format number |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i convert a number into minutes for a time of completion c. | Excel Discussion (Misc queries) | |||
| convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
| How do I convert Military Time to minutes? | Excel Worksheet Functions | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
| Convert Time...!convert tenths of a second | Excel Discussion (Misc queries) | |||
Threaded Mode
