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. Word,Excel and other Apps Icons gone

    in Windows 10 Ask Insider
    Word,Excel and other Apps Icons gone: [ATTACH] submitted by /u/charan_v2 [link] [comments] https://www.reddit.com/r/Windows10/comments/hp5jjq/wordexcel_and_other_apps_icons_gone/
  3. My File Explorer and Excel search functions are not working.

    in Windows 10 BSOD Crashes and Debugging
    My File Explorer and Excel search functions are not working.: My File Explorer and Excel search functions are not working after installation of Titus Data classification tool. what could be the reason. https://answers.microsoft.com/en-us/windows/forum/all/my-file-explorer-and-excel-search-functions-are/785a5c32-aeaf-466a-a1db-b920d88d6b08
  4. Excel macro, if Excel gets the focus.?

    in Microsoft Office and 365
    Excel macro, if Excel gets the focus.?: So I want the macro to start immediately when I switch to Excel from another application with <alt>+<tab>. Excel-Makro, wenn Excel den Focus bekommt.?
  5. Excel file suddenly deleted itself, tried everything to no avail

    in Windows 10 Network and Sharing
    Excel file suddenly deleted itself, tried everything to no avail: I have an Excel file which I regularly use to track data but one day I opened it and all of a sudden it said that it's unavailable. I checked the original location and saw that the file just literally vanished. The file wasn't corrupt or anything. Itliterally doesn't exist...
  6. my excel files corrupt after forced windows update

    in Windows 10 BSOD Crashes and Debugging
    my excel files corrupt after forced windows update: Hi, As usually, I left my programs open and PC on overnight, and Windows possibly made an update and restart. This corrupted my Excel bookkeeping file I've run for 25 years. So far, I've found no way to fix it. The 170 mb file with tens of sheets and hundreds of thousands...
  7. Excel Crash

    in Windows 10 Network and Sharing
    Excel Crash: Excel Office 2010 version crashed, when it restarted it tried to install Office 2010 Pro and I get and install error message 1310 "Writing to C\Program Filesx86\Microsoft Office\Office 14\ Excel.exe Verify that you have access to that directory." When I go to that executable...
  8. Excel files showing up in foreign language

    in Windows 10 Customization
    Excel files showing up in foreign language: I recently started receiving Excel files in English from USA and opening files only to see spreadsheets written in a foreign, maybe eastern european language. Is there any reason this would start happening?...
  9. Need Excel 2010 Macro to insert image over 31 sheets on same cell.

    in Microsoft Office and 365
    Need Excel 2010 Macro to insert image over 31 sheets on same cell.: I have 15 spread sheets. Each one with a front page (sheet = the tabs at the bottom). Tab 2 to tab 32 on the same cell (46 F) I need to insert an image (My digital signature). This means 15 X 31 whereby I have to insert this. I was thinking that perhaps there is a way of...
  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