| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 27707 | 2002-11-29 03:47:00 | Excel for Susan | Shroeder (492) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 102284 | 2002-11-29 03:47:00 | Hey Susan, how did your issue with hh:mm:ss in excel go? If you got it sorted, any idea on how to adjust that format to a percentage of hours eg. so 02:45:00 comes out as 2.75 Ta |
Shroeder (492) | ||
| 102285 | 2002-11-29 04:22:00 | Time values in Excel are stored as a decimal of 24 hours. i.e 0:00:00 hours = 0.0000 and 23:59:59 = 0.99999999 So if you reference a time value and multiply by 24, and format the value to general with 2 dec places, you will get the desired. |
wuppo (41) | ||
| 102286 | 2002-11-29 04:25:00 | ummm I haven't finished sorting that problem out yet. :8} Excel is on the other PC but I'll have a look later. I have got part of the IF formula working by inserting another column that displays the time format in a number format. What I have to do now is complete the rest of the IF formula. Will get back to you on this later on. :-) |
Susan B (19) | ||
| 102287 | 2002-11-29 04:27:00 | Oh, you got there before me Wuppo.... :-) Yes, that's exactly what I've done - multiply by 24. |
Susan B (19) | ||
| 102288 | 2002-11-29 04:28:00 | It would be so much easier if the French Revolution improved decimal time had caught on. :D Some people wouldn't like the 10 day weeks. | Graham L (2) | ||
| 102289 | 2002-11-29 12:31:00 | Another way is to use the built in excel function TIMEVALUE() IE IF($A$3<TIMEVALUE("10:40:00"),"Less the 10:40","Greater or Equal to 10:40") if the Cell A3 contains a time of 06:24:00 then it will return the true value if it contained 10:43:00 then it would return the false value |
Big John (551) | ||
| 1 | |||||