LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.newusers
LM813
 
Posts: n/a
Default Time Sheets (Yes, I've already done a search on previous posts)


ERR229 Wrote:
Hi,

Try this...

=ABS(((A1-A2)*24)+((A3-A4)*24)+((A5-A6)*24))

Hope it helps!
--
ERR229


Yes, that does help! Thank you very much!! :)


--
LM813
------------------------------------------------------------------------
LM813's Profile: http://www.excelforum.com/member.php...o&userid=30385
View this thread: http://www.excelforum.com/showthread...hreadid=500492



 
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
create formula to add 15 minutes to previous time value Bruce Excel Worksheet Functions 2 April 4th 23 10:39 AM
time sheets karen Excel Discussion (Misc queries) 1 July 23rd 05 01:42 PM
CHANGE SET-UP ON MULTIPLE SHEETS AT 1 TIME DEMONET48 Excel Discussion (Misc queries) 2 January 14th 05 08:37 PM
set or reset the print range for several sheets at a time? Mestrella31 Excel Discussion (Misc queries) 2 January 10th 05 09:07 PM
how to open and see 2 excel work sheets at a time cwm Excel Discussion (Misc queries) 3 December 26th 04 01:27 PM


All times are GMT +1. The time now is 05:54 PM.

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"