ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   help with date and time (https://www.excelbanter.com/excel-worksheet-functions/30682-help-date-time.html)

wayne visser

help with date and time
 

I need to be able to read the time logged in (coloum b) to the time out
(coloum c) and insert the time diffrence in (coloum d) with respect to
the date in (coloum a)
and then in (coloum e) i need to multiply the total of coloum d to a
specified total "ie R12.50" to give me the total amount of time done
and the the total amount in cost value I have being batteling with the
time value i tried the the formular under "preforming time calculations
when dealing with both time and date" please can you give me a little
assistance

thanx
wayne


--
wayne visser
------------------------------------------------------------------------
wayne visser's Profile: http://www.excelforum.com/member.php...o&userid=24292
View this thread: http://www.excelforum.com/showthread...hreadid=379005


olasa


Not sure I understand, but this might help:
See encl. pictu
http://www.excelforum.com/attachment...tid=3497&stc=1

Ola


+-------------------------------------------------------------------+
|Filename: Clipboard01.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=3497 |
+-------------------------------------------------------------------+

--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=379005



All times are GMT +1. The time now is 06:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com