Posté par
jacikechina, le Thursday April 17, 2008 11:03:21 AMConfiguration: Windows XP Internet Explorer 6.0
Hai
Have you tried this formula ? Convert time to decimal =HOUR(A2)+(MINUTE(A2)/60) If that doesn't help here is a list of hints on similar issues that might help you. http://www.exceltip.com/exceltips.p.... |
I have problem on adding time in excel for AM and PM. For instance, time starts at 5:45PM, time break at 8:00PM to 8:30PM, and ending time at 6:00AM. Time work for 5 days a week. Please help me to find better formula calculating timecard each week. Total time for one day is 12 hours but 8 regular hours + 3.5 overtime hour. |
| 26/02 15h05 | How to make a video clip ? | Video |
| 10/06 15h28 | Lotus to Excel formula conversion | 1 |
| 17/04 13h32 | Lotus to Excel formula conversion p | 1 |
| 14/05 16h03 | Excel question - conditional format | 3 |
| 30/04 03h22 | Excel autofilter stops filtering | 12 |
![]() | Excel Viewer - With Excel Viewer, you can open, view, and print Excel workbooks, even if you don't have Excel installed. You can also copy... | Category: Office suite License: Freeware/gratuit |
![]() | Videora Xbox360 Converter - ideora Xbox 360 Converter is a free Xbox 360 video converter that converts video files, YouTube videos, movies and DVD's so... | Category: Video editing License: Freeware/gratuit |
![]() | Videora Ipod converter - Videora iPod Converter is a free iPod video converter that converts video files, YouTube videos, movies and DVD's so you can... | Category: Video editing License: Freeware/gratuit |
![]() | PSP Video 9 - PSP Video 9 is a free PSP video converter that converts video files, YouTube videos, movies and DVD's so you can play them... | Category: Video editing License: Freeware/gratuit |