Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Excel Time calculations
Name: issolla Date: November 9, 2006 at 00:18:41 Pacific OS: win 2000 CPU/Ram: 256 Product: HP
Comment:
Hi , I would like to do the substractions from the cells which is in time format. Supporse I have 2 cells. one is Starting time (16:31:44) and the other is ending ime (16:32:45). If I calculate manually the the duration is 61 Minutes. How to do this using excel formula?. Is there any method in Excel? -Thanks
Summary: Hope someone can help..2 issues here when my data arrives in Excell I need it to be in HH:MM for time calculations..correct? however my data appears XXXX example 647 instead of 06:47. how can I do thi...
Summary: Hi, Can I ask that you start a new thread. It makes it easier to track topics. Use a title that describes the issue such as Excel time calculation after midnight. In the body of the question be as spe...
Summary: I have a problem calculating time in Excel. For example, in column A the time is 30:20(30 hours and 20 minutes), how can I turn the minutes into hours in Column B and get the answer of 30.33. If the h...