Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do i calculate hours/minutes in a billing format.
I have a template that i downloaded... i need to calculate the hours table so
that it multiplies as hours and minutes... |
#2
|
|||
|
|||
This may give you an idea about how to go about it:
' a Macro to calculate the elapsed time for formfields with Date format of HH:mm ' Start = ActiveDocument.FormFields("Text1").Result StartHour = Val(Left(Start, 2)) StartMinutes = Val(Right(Start, 2)) StartTimeMinutes = StartHour * 60 + StartMinutes Finish = ActiveDocument.FormFields("Text2").Result FinishHour = Val(Left(Finish, 2)) FinishMinutes = Val(Right(Finish, 2)) FinishTimeMinutes = FinishHour * 60 + FinishMinutes ElapsedMinutes = FinishTimeMinutes - StartTimeMinutes ElapsedHours = Int(ElapsedMinutes / 60) ElapsedMinutes = ElapsedMinutes - ElapsedHours * 60 ActiveDocument.FormFields("Text3").Result = Str(ElapsedHours) & ":" & Format(ElapsedMinutes, "00") -- Please respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP "msmo" wrote in message ... I have a template that i downloaded... i need to calculate the hours table so that it multiplies as hours and minutes... |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a template for a research paper in APA format? | Microsoft Word Help | |||
date format change when using serial printing | Microsoft Word Help | |||
In Word 2003, how to get rid of the 5x 7 in balloon format in the. | Page Layout | |||
Maintaining the format of linked tables. | Tables | |||
time format in comments on changes | Microsoft Word Help |