Question about Microsoft Computer Utilities & Maintenance

1 Answer

Sum of hours using military time after 2400.

I'm trying to build a formula to give me the total hours if worked after midnight of I started before midnight.Example; 2100 hours on the 15th to 0200 hours on the 16th. If I start a job at 2100 hours on the 15 and finished it at 0200 hours on the 16th what formula would calculate the sum of hours worked?

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

Titi mo lumalaki

Posted on Mar 03, 2009

Add Your Answer

Uploading: 0%


Complete. Click "Add" to insert your video. Add



Related Questions:

1 Answer

I cant start Trojan killer although I should have 15 days to test this program.\r\nBut i installed the program today and didnt use it any second. So why can't I use this program , just 1 time ? Thanks-...

Usually they still would want you to register, if you haven't done this, you won't be able to use it. I can suggest a totally free version of Malwarebytes, which is a great package and will not conflict with other antivirus software. It's also possible that the Trojan Killer won't run because of conflicts. If you want to try Malwarebytes, I suggest you uninstall the Trojan Killer first.
You can run a quick scan first and, you will want to run a full scan when you have 2 hours to dedicate to the scan.

Jun 14, 2011 | GridinSoft Trojan Killer

2 Answers

Error Fix When scanning Registry, the window

Hi there,

You can always close your application in the task manager, simply right click next to the the tray icons, select Task Manager and then choose the program or process you want to close :O) (all programs has at least one process).

What kind of cleaner do you use ?? Take care with these registry cleaners they can make a mess :oO. Read my article here, this is a reliable registry cleaner :

Have a nice time over there

Let me know :O)

Dec 05, 2009 | Computer Utilities & Maintenance

1 Answer

I have an assignment where 4 worksheets were provided. I did autosum for the total amounts on each sheet. I need to make a summary sheet now to add all of those totals What formula and steps do I take? ...

I'd say you need to pay better attention to the Excel or other spreadsheet books and help you have handy, and categorize your problem according to the behavior you get inconsistent with the suggested solutions already available.

No excuse for your laziness!

Nov 13, 2009 | Computer Utilities & Maintenance

1 Answer

Excel formulas

Below is the formula for "2". The logic should be obvious from this so you can adapt for "1" or a combination of 1 and 2. This need to be written as one long formula so I have pasted it in to this reply so you can do a copy and paste into your spreadsheet. Sorry its not very readable in this form but you could paste into word so you can break it down and examine structure.

=IF(OR((AND(Sheet3!A12="WA",OR(Sheet3!AH2="Lewis",Sheet3!AH2="Pacific",Sheet3!AH2="Wahkiakum"))),(AND(Sheet3!A12="OR",OR(Sheet3!AH2="Clackmas",Sheet3!AH2="Multnomah",Sheet3!AH2="Washington")))),"X"," ")

Aug 18, 2009 | Microsoft Office Excel 2007 Full Version...

2 Answers

Trend micro slowing my computer down

Unistall the software in safe mode and try to install it again.
Thanks!!! PREM

Mar 12, 2009 | Trend Micro AntiVirus plus AntiSpyware...

1 Answer

Pls. help me

Q.2#  Dim n, sum as Double
Dim i as Integer

for i=1 to n
next i

Q.3#  Dim sum as Double
for i=1 to 99
if i%2 <> 0 then sum=sum+i end if
next i

Sep 16, 2008 | Microsoft AccRepair DS2 2004 for Fr...

1 Answer

HP Scanjet 2400 Driver Software

follow this link then choose accdng to your operating system:

Sep 14, 2008 | Computer Utilities & Maintenance

1 Answer

Game not playing.

A few questions need to be asked before i can give you a resalution to this one.
1Where did you donload the game from?
Have you a anti-virus running in the background.
What other programes do you have running in the background.

mainsse2.exe stops working usually due to
A) antivirus programe or
B)spam or spyware.
IF you can get back to me with answers to those questions
I could then give you a fix.

Feb 22, 2008 | Computer Utilities & Maintenance

Not finding what you are looking for?
Computer Utilities & Maintenance Logo

Related Topics:

158 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computer Utilities & Maintenance Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18299 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 1 Expert

12 Answers

Are you a Microsoft Computer Utility and Maintenance Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides