LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default Subtracting Time can it be done with a fx?

I have a co-worker that is trying to create a spreadsheet to keep track of
how many minutes it takes to complete drafting projects. He wants to be able
to enter his start time in one cell, his finish time in another cell and be
able to get a result of how much time it took in minutes or hours in another
cell. For example, he starts and enters in a cell 2:00p.m. then in the next
cell he finished at 3:30p.m. he wants a result cell to show 90 minutes. Of if
he uses military time he wants the same results. Is there a function that
will calculate time like this?
 
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
subtracting time Sam Excel Worksheet Functions 1 May 27th 06 09:55 AM
Subtracting time quartz Excel Worksheet Functions 3 May 18th 05 08:07 PM
Subtracting Time Jason Excel Worksheet Functions 2 April 15th 05 09:07 PM
Subtracting Time from NOW() Value Trying to excel in life but need help Excel Worksheet Functions 2 April 11th 05 12:01 AM
Subtracting time Pantryman Excel Worksheet Functions 6 November 24th 04 08:53 PM


All times are GMT +1. The time now is 02:59 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"