LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 58
Default Time sheet Formula

I have a sheet where I am trying to calculate hours worked against hours
allowed.

I am able to add the hours worked in a period but when I try to subtract the
hours worked from the hours allowed I get an error if the hours worked are
lower than what is allowed.

This is what it looks like:

hours worked 42:26:00 29:31:00
hours allowed 41:00:00 38:00:00
Over Budget 1:26:00 ########################


The formula for over budget is as follows:
=IF(D29<0,(D29-D30)," ")

Does anyone know how to make this work show it shows me the correct
information?

Thanks in advance.
Ed Davis

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Time sheet formula? Basic DB Question Excel Discussion (Misc queries) 2 February 8th 07 04:02 PM
Help With Time Sheet Formula BECKYB913 Excel Discussion (Misc queries) 3 December 5th 06 03:11 PM
Formula for a time sheet lee Excel Discussion (Misc queries) 3 August 25th 06 04:54 PM
How do I set up a formula on a time sheet to calculate time in 1/. gschmid Excel Discussion (Misc queries) 2 January 18th 05 01:48 PM
formula to calculate a time sheet tintin103 Excel Worksheet Functions 1 January 17th 05 09:45 PM


All times are GMT +1. The time now is 05:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"