![]() ![]() If you want to convert the answers from fractions of a day to hours as units, just multiply by 24 (!). ![]() You can of course format the sum cell to show the answer in whatever form you prefer (hours, days etc).įor example if you want to display it as 36:15 then use the custom number format: If you enter those times in cells C2:D6 and I will assume you use standard (24 hour) notation, then the following formula entered in E2 and copied down should give you what you want:ĭepending on your cell formatting, that can show as a decimal or hours : mins, but fundamentally, the cells contain a number that is the portion of a day in each case giving the following (in hours:mins):ġ.510416667 (as a decimal) which is just over 1.5 days or just over 36 hours in total (36 hours, 15 mins to be precise). Reply: hours worked - allen from oakland, ca wrote on Aug6:48 PM EST If I work for $15 an hour how do I calculate this using my time calculation? "I can add time together to give the total amount of hours and minutes worked in a week eg 35:30.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |