programAngel Posted January 28, 2010 Share Posted January 28, 2010 Hi I need to use excel or any type of spreadsheet to calculate my work hours. In other words I need to calculate how many hours did I work. Anyway I used excel in one square I write the time that I begin, like for example 5:30, in other square I write the time I finished to work like 14:00. Now what function can I used that it will calculate that time that I worked in hour unit. So that in the case of the example it will give me 8.5 hours. Thanks for the help. Link to comment Share on other sites More sharing options...
Rakdos Posted January 29, 2010 Share Posted January 29, 2010 Only way I could see this work is if you convert the times to decimal so the 8:30 would become 8.5, then you can just use the normal math functions built into excel for it, but that won't work well if you get off at strange times like 8:27. Link to comment Share on other sites More sharing options...
programAngel Posted January 29, 2010 Author Share Posted January 29, 2010 That is why I ask whether there is a function in spreadsheet that can calculate this without me changing 8:30 to 8.5 Link to comment Share on other sites More sharing options...
Klaynos Posted January 29, 2010 Share Posted January 29, 2010 I'm guessing here, but if you set the cell format to time will it not just allow you to subtract one from the other? Link to comment Share on other sites More sharing options...
the tree Posted January 29, 2010 Share Posted January 29, 2010 You definitely can in Open Office, I'd assume you can do the same in Excel - just right click on a cell/bunch of cells and select format. Link to comment Share on other sites More sharing options...
john5746 Posted January 29, 2010 Share Posted January 29, 2010 That is why I ask whether there is a function in spreadsheet that can calculate this without me changing 8:30 to 8.5 You might be looking for something like this? =HOUR(B1-A1) + MINUTE(B1-A1)/60 Where A1 is the beginning time, B1 is the end time. A1, B1 would be formatted as simple time, the result cell would be formatted as general Link to comment Share on other sites More sharing options...
Mr Skeptic Posted January 30, 2010 Share Posted January 30, 2010 If Excel doesn't understand time-formatted math, just put the hours and minutes in different cells. Link to comment Share on other sites More sharing options...
insane_alien Posted January 30, 2010 Share Posted January 30, 2010 openoffice calc can do this if the cells containing the times are formatted as containing a time. i imagine excel should do this too, if it can't then it isn't really much of a spreadsheet program as they are commonly used to contain and calculate time based data. try looking in the help. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now