Windows 10: Excel time calculations

Discus and support Excel time calculations in Microsoft Office and 365 to solve the problem; I've searched here and the internet and followed examples but still get stuck on this problem. I've a spreadsheet column of hhmm local cities and... Discussion in 'Microsoft Office and 365' started by Doc943, Aug 6, 2018.

  1. Doc943 Win User

    Excel time calculations


    I've searched here and the internet and followed examples but still get stuck on this problem.

    I've a spreadsheet column of hhmm local cities and times that I want to populate an adjacent cell with UTC hhmm. For example, Melbourne (Aust.) 0900 is (currently) 2300 UTC, 10 hrs difference. I've tried using 10/24ths or the TIME(10,0,0) or MOD function added/subtracted to 0900 but never get 2300. Arghhh. Maybe my cell format is wrong but I've tried all sorts including custom.

    Help appreciated. Not an important problem but silently driving me mad *Confused

    :)
     
    Doc943, Aug 6, 2018
    #1
  2. Theurgist Win User

    Excel 2007 copy to Excel Mobile

    I have a spreadsheet in Excel 2007 with tons of calculations. I tried to copy this file to my mobile device excel mobile. The spreadsheet copies and works except none of the calculations are there. Any suggestions?
     
    Theurgist, Aug 6, 2018
    #2
  3. Calculator

    I have upgraded to Windows 10 and have found the following.

    With the versions of Calculator up to and including Windows 7 it was possible to copy (Ctrl + C) from Calculator and paste (Ctrl + V) to another application e.g. Excel.

    Windows 10 has taken a backwards step because Ctrl + C (copy) from Windows 10 Calculator and Ctrl + V (paste) to Excel does not work.

    Any chance of this being corrected, preferably soon, or is this considered a step forward.

    'Current operating system' below does not include Windows 10 so I have had to choose 'Other'.

    ***Post moved by the moderator to the appropriate forum category.***
     
    lewishilary, Aug 6, 2018
    #3
  4. malware Win User

    Excel time calculations

    Microsoft Excel 2007 Calculation Issue Fix Available

    Two weeks ago, an issue involving the calculation of numbers around 65,535 and 65,536 has been found in Microsoft Excel 2007. If you try to calculate "=850*77.1" in Excel 2007, it will display an incorrect value, but if you then multiply the result by 2, you will get the correct answer. As of today, fixes for this issue in Excel 2007 and Excel Services 2007 are available for download here. Microsoft is in the process of adding this fix to Microsoft Update so that it will get automatically pushed to users running Excel 2007 or Excel Services 2007. Additionally, the fix will also be contained in the first service pack of Office 2007 when it is released. The release date has not yet been finalized.

    Source: MSDN blog
     
    malware, Aug 6, 2018
    #4
Thema:

Excel time calculations

Loading...
  1. Excel time calculations - Similar Threads - Excel calculations

  2. msointl.dll with Word and Excel

    in Microsoft Office and 365
    msointl.dll with Word and Excel: I've tried to resolve this issue and it's not working I also tried Microsoft solution and it didn't work either. Any way to fix this? This is Office 2010. Thank you [img] [img] 139067
  3. What would be the commands for running Word and Excel?

    in Windows 10 BSOD Crashes and Debugging
    What would be the commands for running Word and Excel?: Because with troubleshooting and I had to kill off Windows Explorer, that I would be needing the Word app then, so what would be the command I have to key-in the task manager? Also with Excel? TIA....
  4. Can Word and Excel be opened while in safe mode?

    in Windows 10 BSOD Crashes and Debugging
    Can Word and Excel be opened while in safe mode?: So I couldn’t use it then while in safe mode? https://answers.microsoft.com/en-us/windows/forum/all/can-word-and-excel-be-opened-while-in-safe-mode/04693d51-91dd-4618-b88a-214f54f94f85
  5. Converting Excel Data to Powershell Script

    in Windows 10 Network and Sharing
    Converting Excel Data to Powershell Script: How would I go about converting Excel Data to Powershell Script? https://answers.microsoft.com/en-us/windows/forum/all/converting-excel-data-to-powershell-script/5c4fc5ae-3d65-4f9e-aef3-f6daad5910de"
  6. Excel problems due to 1903 Windows 10 recent update

    in Windows 10 Installation and Upgrade
    Excel problems due to 1903 Windows 10 recent update: I can no longer add a comment to a cell in Excel, unless I use hot keys. The right-click menu has changed, eliminating the option to add a comment. When will it be fixed? What else might be wrong that I just haven't found yet?...
  7. Excelling at failing Excel

    in Windows 10 Software and Apps
    Excelling at failing Excel: First off, I’m an Excel idiot. I use Word exclusively, and only use Excel when it’s someone else’s document and I don’t have a choice. Now would be one of those times. I do want to learn, but right now, I’m an idiot. At work, there’s an Excel spreadsheet that freezes when...
  8. PDF Excel and other office files showing file type as Folder and not opening with Office tools

    in Windows 10 Network and Sharing
    PDF Excel and other office files showing file type as Folder and not opening with Office tools: Can anyone help me to open these files with their respective file extensions? Pdf with adobe reader, excel extension with Excel etc.? All of these files seem to be corrupted. The icons of all these documents are changed to the folder icon and when looked into properties,...
  9. Excel macro stopped working after upgrading to v.1903

    in Microsoft Office and 365
    Excel macro stopped working after upgrading to v.1903: I hate this kinda stuff. My desktop was working fine. So I gave in and installed the update v.1903 and now all I have to do is fix problems *Sad (Teaches you something about those updates, doesn't it?) So I have this Excel file that has my own signed macros in it. It used to...
  10. Can't paste into Calculator from Excel

    in Microsoft Office and 365
    Can't paste into Calculator from Excel: As per title, because there's a dollar sign in the figure. Win7 did this very well... ffs 21718