spreadsheet question figuring time clock?
346778
use time function. =time() and use add and subtract formulas to customize as per ur requirement
447208
OK. two things to do. Let's assume your 225 minutes are in cell A1\n\n\n=INT(A1/60) ;This gives you the hours\n\nNext\n\n=MOD(A1/60) ; This gives you the remaining minutes.
1164923
yahoo widgets has a clock that would do what you want.\n\nthe Floresense WorldClock widget lets you add multiple cities to the widget and it shows the current time in each.
630142
Set up a loop like this:\n\nExitFlag=false\nDo\n   Range("B8") = Format(Now(), "HH:MM:SS")\n   DoEvents\nLoop Until ExitFlag=true\n\nThe point of my variable ExitFlag is that you might want to break out of this loop at some point.  You could set this variable in a macro for pushing a Cancel button - if needed.  You don't have to have it though, you could just use Do... Loop\n\n(A more efficient way is to link this to some kind of system timer event, but I don't know how to do that in Excel.)
411262
You need a special made function:\nTry this\nput start time in A1\nput end time in B1\nput this fumction in C1\n=HOUR(B1) -HOUR(A1)&":"&MINUTE (B1)-MINUTE(A1)\nThis will work if both time are in the same day\n\nI had to put spaces for you to read, remove them.\ne-mail me for further info\n\nXLMan
611065
click on the clock,and change the date
598049
this will help\nhttp://www.timezoneconverter.com/
379139
10 am Hong Kong Time\n\nhttp://www.timeanddate.com/worldclock/\n\nhttp://www.hkex.com.hk/tradinfo/tradcal/tradcal_1.htm
469972
the day, month, and year will all be one number apart, when the clock gets to 1:02:03\n01:02:03, 04/05/06
153328
on windows xp, right click on taskbar and select properties. then check the "Show the clock" option.
844456
Insert this for the Date:\n<h4>It is now  \n<script type="text/javascript">\n<!--\nvar currentTime = new Date()\nvar month = currentTime.getMonth() + 1\nvar day = currentTime.getDate()\nvar year = currentTime.getFullYear()\ndocument.write(month + "/" + day + "/" + year)\n//-->\n</script>\n</h4>\n\nInsert this for Time:\n<h4>It is now  \n<script type="text/javascript">\n<!--\nvar currentTime = new Date()\nvar hours = currentTime.getHours()\nvar minutes = currentTime.getMinutes()\nif (minutes < 10)\nminutes = "0" + minutes\ndocument.write(hours + ":" + minutes + " ")\nif(hours > 11){\ndocument.write("PM")\n} else {\ndocument.write("AM")\n}\n//-->\n</script>\n</h4>
206954
Excel stores dates and times in days.  If you subtract one time from another, the result will be in days.  Multiply by 24 to convert to hours.\n\nTo display tenths of an hour, format the cells to display tenths.\n\nTo always round up, add 0.05 hour.\n\nFor example, an employee starts work on March 12, 2006 at 8:05 and punches out at 5:11.  When you subtract the start time from the end time, you get 0.3796 days.  To get hours, multiply by 24: 9.11 hour.  To round up, add 0.05 hour: 9.16 hour rounds to 9.2 hour.
1162831
hh:mm:ss\n4:00:40 or\n8:00:20
219942
the answer is time or the minutes pointer in a watch
371049
It's quirky, but you can do it...\n\nAll times in Excel are DateTimes, so you have to provide a day. Also, remember that the formatting is important.\n\nIn one cell, put "1/1/2006 9:00 am", in another put 1/1/2006 5:00 pm"\n\nIn a third cell, subtract the second cell from the first.\n\nNow it works, but it doesn't look right because its showing you a date as well as a time. Highlight all three cells, and go to "Format | Cells" and set the format to "hh:mm" Now the cells look like:\n\n9:00 am\n5:00 pm\n8:00\n\nVoila!
93816
World times can be found on this web-page...\nhttp://www.timeanddate.com/worldclock/
270897
1:45:25 PM\n\nWell, that was, was being the key word here, the time when I posted. In order to get pacific time when you're in the eastern time zone, simply subtract 3 hours from your time, nothing else, and you'll get the exact time. Not to sure about Mountain time or Central.