French versionSpanish versionEnglish versionSign up for free (lost password?)
- Thursday August 7, 2008 - 9:09:20 pm BST
- registered : 909661
- online : 36750
- questions/day : 4155
- Answer rate : 83.67%
Code to convert into mail in excel format in .net Convert vista excel to xp excel Converting date format to system date format in excel Converting text into integer excel Excel Excel viewer 2007 File conversion excel 2007 to 2003 Lotus converting to excel problems with formulas Mail merge excel decimal point Vlc converterPlus
They need your help
- 20:07 boot issue. Screen doesn't come on,... (Hardware)
- 20:06 forgotten vista admin password - help (Windows)
- 17:18 active row range from sheet1 to sheet2 (Office software)
- 17:07 Keyboard help (Windows)
- 15:10 html fonts (Software)
- 14:41 virtual memory low (Windows)
Statut : Not resolved
Posté par 
jacikechina, le Thursday April 17, 2008 11:03:21 AM
Convert Time To Decimal In Excel
Posté par jacikechina, le Thursday April 17, 2008 11:03:21 AMHello,
I have set up a simple timecard in Excel. There is a time field for clocking in, and another for clocking out. I want Excel to then calculate the number of hours worked. I have used the advise on this site for the subject I am writting about.
The advice here has helped me in the same way. Only, I have a problem along the same line, excel will not calculate time in my example.
I have a clock in time of 9:00 PM and a clock out time of 1:00 AM. for some reason I get #### and a message that reads "Negative dates or times are displayed as ####". If I try to reverse the cells in the formula field, I get 20:00. Any help with this would be greatly apperciated.
I have set up a simple timecard in Excel. There is a time field for clocking in, and another for clocking out. I want Excel to then calculate the number of hours worked. I have used the advise on this site for the subject I am writting about.
The advice here has helped me in the same way. Only, I have a problem along the same line, excel will not calculate time in my example.
I have a clock in time of 9:00 PM and a clock out time of 1:00 AM. for some reason I get #### and a message that reads "Negative dates or times are displayed as ####". If I try to reverse the cells in the formula field, I get 20:00. Any help with this would be greatly apperciated.
Configuration: 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.... |
| tudo99, on Tuesday May 27, 2008 11:56:47 AM 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. |
Tips & Tricks relevant found in the knowledge base
More tricks on « Convert Time To Decimal In Excel »
| 26/02 15h05 | How to make a video clip ? | Video |
Relevant topic found in the forum
More discussions about « Convert Time To Decimal In Excel »
| 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 |
Software found in the relevant downloads
More freeware about « Convert Time To Decimal In Excel »
 | 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 |